View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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!