Calculating new dates

T

Talitha

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

Chip Pearson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top