MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Easy one!


Posted by Jane H on January 10, 2002 5:47 AM

I am using a nested IF statement and want one of the conditions to be based on today's date less 6 months (ie 6 months ago). What is the formula?

So far I have got
=IF(AND(C4>=20,F4=NOW()-MONTH),"YES","NO")


Posted by George J on January 10, 2002 6:28 AM

=TODAY()-(365.25/2)
This should get you today-6 months

George

Posted by Jane H on January 10, 2002 7:30 AM

Thanks George


Posted by Jane H. on January 10, 2002 7:31 AM

Thanks George


Posted by Jane H. on January 10, 2002 7:31 AM

Thanks George