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