Calculate 60 days from Start Date - including weekends

[Missy]

How could I calculate 30, 60, 90, etc. days from a start date? I want to
include weekends - not the WORKDAY function with only the work week.
THANKS!!

 

[Glenn]

How could I calculate 30, 60, 90, etc. days from a start date? I want to
include weekends - not the WORKDAY function with only the work week.
THANKS!!

Look at "Add dates" in the help file.

 

[Rick Rothstein]

To Excel, dates are just numbers (the number of days offset from January 1,
1900), so for what you have asked... just add the number of days you want to
the date you have (this just extends the offset from the date you have by
the number of days you want to add to it). So, if your start date is in A1
and you want to add 30 days to it...

=A1+30

 

[JP Ronse]

Hi Misy,

Having a data in A1, e.g. 01/01/2009
in A2: = A1+30 => 31/01/2009
in A3: =A1+60 => 02/03/2009
in A4: =A1+90 => 01/04/2009

Note that the calculated days are not fally on the same weekday.

If your intention is to calculate the same date of a month given a startdate
(+ 30 is 1 month, +60 = 2 months, ...)
01/01/2009 => 01/02/2009

=DATE(YEAR(A1);MONTH(A1)+1;DAY(A1))

You probably have to change the ";" into "," to get the function working.

Wkr,

JP

 

[Missy]

THANK YOU THANK YOU!! So simple - sorry for the question!!

 

[JP Ronse]

You're welcome and we appreciate the feedback.

THANK YOU THANK YOU!! So simple - sorry for the question!!