Quote:
Originally Posted by ArviLaanemets
Code:
=IF(MONTH(TODAY()) = 3*INT((MONTH(TODAY())-1)/3)+n,$F1,"")
where n is quarter month number, you want the formula to return the result for (1, 2, or 3)
|
Arvi, I had been trying to figure out this formula. I listed in column E all the months in a year then changed "TODAY" to E1, E2..... January is 1, February is 2. I can not understand why the formula (=month(E1)=3.....)still returns the value of F1 when January is less than 3. Could you explain its syntax please.