Creating a cell that can automatically move forward 90/120/30 days

  • Thread starter Thread starter jclarksonjr
  • Start date Start date
J

jclarksonjr

I need to make a cell change the date to a new date pre-determind on
quaterly,weekly,monthly,annual schedule for scheduling of maintenance
I want to be able to start with a date then have it autmatically chang
to 90 days later at the end a schedule window. so 3 cells center on
with date first one with early date, last one with late date and at th
that date change the center one to a new start date thus moving th
maintenance window forward 90 days
 
not sure if this is what you want but if today() + X is the startin
date then I think rounddown((today()+x)/90,0)*90 will stay constant fo
90 days and then increment by 90 day
 
Back
Top