Calculating new dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I've been searching the Excel helpfiles and I found a lot of functions that can help me calculate the number of days between 2 different dates, but I can't find one where I tell the formula to add 90 days, for example, to a specific date and then give me the new date.

Is it possible? If it is, how do I do it?

Any help would be appreciated.

Thanks!
 
Talitha,

You can add days to a date by simply adding that number to the date. For
example,
=A1+90
will add 90 days to the date in cell A1. If you want to skip weekends, use
the WORKDAY function. E.g,.
=WORKDAY(A1,90)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)


Talitha said:
Hi

I've been searching the Excel helpfiles and I found a lot of functions
Click to expand...
that can help me calculate the number of days between 2 different dates, but
I can't find one where I tell the formula to add 90 days, for example, to a
specific date and then give me the new date.
 
Back
Top