| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If I have date, can excel calculate the day for me? | Excel Discussion (Misc queries) | |||
| How to get the Excel to calculate the exact date from a given date | Excel Worksheet Functions | |||
| How do I calculate a future date in excel? | Excel Worksheet Functions | |||
| How do I calculate a future date in Excel? | Excel Worksheet Functions | |||
| Calculate a Date In Excel | Excel Discussion (Misc queries) | |||
Linear Mode
