recurring dates

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

Guest

I need to be able to set set a deadline based on prior dates. These can go
back years. I would like to set up a current 'next appointment, for instance
ever 90 days, based on a date of arrival. For example, if date of arrival is
2/13/03, how do I make a formula that is effective now. In other words, the
cell updates to a new deadline every ninety days, and stays current.
Thanks a bunch.
 
Maybe this which calculates the number of 90 day periods that have elapsed
since the start date.

=(FLOOR((A1-TODAY())/90,1)+1)*90+A1

Understand though that working with dates is tricky. There is a big
difference between 90 days, 3 months and one quarter of a year so if you
weren't looking for exactly 90 day intervals this probably won't meet your
needs.

PC
 
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 Colour code dates 1
Network days 3
Add-in WITH worksheets?? 1
Dates and Formulas 2
Help with formula 1
Calculating whether solution is in time or not 4
Recurring appointments based on other appointments 2
Working with dates 4

Back
Top