Date formula

  • Thread starter Thread starter bettnap
  • Start date Start date
B

bettnap

I would like to have a calculation from a date I enter and
data I download. I enter a date as follows 2/27/04 for a
report each day. I download data with a 3/1/04, 4/1/04
for each month. I need to caluclate the date 90 180 and
240 days out. However while I do a new date each day
(ex: 2/27/04, 2/28/04 3/01/04, 3/02/04...). The download
data is always the first day of the month. So for
February it needs to be 90 days from February 1, until
March 1 then it is 90 days from that date until the next
month and so on.

Is there away for me to make a formula that takes out the
27 and replaces it with a one each day and subtracts from
the downloaded date?

Thanks
 
If I understand your question properly, use, for example:

=date(year(a1),month(a1),1)+90
 
Back
Top