Calculate 60 days from Start Date - including weekends

M

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

Glenn

Missy said:
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!!
Click to expand...


Look at "Add dates" in the help file.
 
R

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
 
J

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
 

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

Similar Threads

How to calculate dates 6
Calculate End Date (excluding weekends and holidays) 6
Date Calculation Formula- Calendar days minus Holidays 1
How do I calculate future date after number of days 1
Workday function question 2
calculating a date with the CHOOSE function 4
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Use networkdays INCLUDE weekends, Exclude holidays 4

Top