I am trying to create a formula that says if today's month and day are the same as the date in C12 to update the cell with the number in AD12. If not, keep the number that is there.
The formula does not have an error, however it is giving me the (ad12-Ae12) answer even if the month and day are the same.
What is wrong?
IF(AND(MONTH(C12),DAY(C12)=(AND(MONTH(TODAY()),DAY(TODAY())))),AD12,(AD12-AE12))
Thanks,
Bookmarks