More date calculations
 

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!

More date calculations
 

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

=A2-2

and in A4:

=A2-28
--
Gary''s Student - gsnu200777


"hurds999" wrote:

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!