Taryn New Member Jan 31, 2023 #1 Can anyone help me with a formula that returns a value if a month falls between 2 dates please? I want columns S-AP populated with K/H and blank if the month doesn't fall within the dates TIA Attachments test.xlsx 20.6 KB · Views: 12
Can anyone help me with a formula that returns a value if a month falls between 2 dates please? I want columns S-AP populated with K/H and blank if the month doesn't fall within the dates TIA
V vletm Excel Ninja Jan 31, 2023 #2 Taryn to cell S10 =IF(AND($F10<=S$9,$G10>=EOMONTH(S$9,0)),$K10,"") and copy as You need
Taryn New Member Jan 31, 2023 #3 vletm said: Taryn to cell S10 =IF(AND($F10<=S$9,$G10>=EOMONTH(S$9,0)),$K10,"") and copy as You need Click to expand... Amazing thank you!
vletm said: Taryn to cell S10 =IF(AND($F10<=S$9,$G10>=EOMONTH(S$9,0)),$K10,"") and copy as You need Click to expand... Amazing thank you!
B bosco_yip Excel Ninja Feb 1, 2023 #4 A bit different idea approach, my way is based on the Start Date column F and Month column H. In S10 copied across and down: =IF($K10="","",IF(AND(S$9>=(EOMONTH($F10,-1)+1),COUNT($R27:R27)<$H10),$K10,"")) Regards Last edited: Feb 1, 2023
A bit different idea approach, my way is based on the Start Date column F and Month column H. In S10 copied across and down: =IF($K10="","",IF(AND(S$9>=(EOMONTH($F10,-1)+1),COUNT($R27:R27)<$H10),$K10,"")) Regards
