How do I calculate a due date in excel

's Computer Specifications

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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message news:14E839A6-A073-4F54-9044-(E-Mail Removed)...
>i have an effective date and an expiration date. Can excel alert me when the
> expiration date is due by inserting a formula.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculate due date excel	=?Utf-8?B?Q29tcHV0ZSBvY2N1cmVuY2Ugb2YgZGF0ZXM=?=	Microsoft Excel Crashes	1	15th Jul 2006 01:30 PM
How to get the Excel to calculate the exact date from a given date	=?Utf-8?B?UGhpbA==?=	Microsoft Excel Worksheet Functions	10	28th Apr 2006 07:07 PM
Re: Excel: auto-calculate a date 2 weeks after an initial date	Frank Kabel	Microsoft Excel Worksheet Functions	0	22nd Sep 2004 09:16 PM
Re: Excel: auto-calculate a date 2 weeks after an initial date	RagDyer	Microsoft Excel Worksheet Functions	0	22nd Sep 2004 09:12 PM
Excel: auto-calculate a date 2 weeks after an initial date	=?Utf-8?B?c2ZmYW4yMDA0?=	Microsoft Excel Worksheet Functions	0	22nd Sep 2004 09:05 PM