How do I calculate a due date in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have an effective date and an expiration date. Can excel alert me when the
expiration date is due by inserting a formula.
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula - Count Dates from another Sheet 8
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
Excel How to calculate in excel number of open actions that expired (older then today) 0
Creating an update query that uses multiple parameters 2
Formula problem 2
Conditional formatting dates 3
Excel Excel due and overdue date colours 2
Dates and Times 1

Back
Top