More date calculations

  • Thread starter Thread starter hurds999
  • Start date Start date
H

hurds999

I am trying to calculate a date for a timeline (this is when this part needs
to be done). So I have the date of the class in A2. I would like to
calculate that the roster needs to be printed 2 days before the class in A3
and the date to send out class offering notices 4 weeks prior to the class
date in A4. How would the formulas look for these two instances, please?

Thank you again, very very much!
 
Fortunately, date are just numbers with a nice format. So in A3:

=A2-2

and in A4:

=A2-28
 
Back
Top