How do I calculate a due date in excel
 

i have an effective date and an expiration date. Can excel alert me when the
expiration date is due by inserting a formula.

How do I calculate a due date in excel
 

Hi Connie

You can use this for example to display yes when the date in E1 is within 30 days of today's date
Change the 90 to the days you want (0 for example)

=IF((E1-TODAY())90,"No","Yes")


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Connie" wrote in message ...
i have an effective date and an expiration date. Can excel alert me when the
expiration date is due by inserting a formula.