Hello All,
i have the following formula and it wont work when i add the edate function and text function.
Basically i have a drop down in cell C3 (monthly and daily) and start date in c4 and an end date in C5.
E3 = the start date using this formula =IF($C$3="daily",C4,TEXT(C4,"mmm-yy"))
and e4 down should then be the next day or next month depending on C3.
I've been trying to do this with the formula below but i just cant get it to work. Ideally i'd like it to display nothing when the end date it reached.
This wont work
=IF(AND($E3<=$C$5,$E$2="monthly"), TEXT(edate(E3,1), "mmm-yy"), IF(AND($E3<=$C$5,$E$2="daily"),E3+1,""))
Any help would be great.
Bookmarks