More date calculations

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!
 
G

Gary''s Student

Fortunately, date are just numbers with a nice format. So in A3:

=A2-2

and in A4:

=A2-28
 
Top