Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate 60 days from Start Date - including weekends
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!! |
#2
|
|||
|
|||
Answer: Calculate 60 days from Start Date - including weekends
To calculate a date that is 60 days from a start date, including weekends, use the following formula:
Formula:
You can adjust the number 60 in the formula to calculate different numbers of days from the start date. For example, to calculate 30 days from the start date, you would use: Formula:
Formula:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate 60 days from Start Date - including weekends
Missy wrote:
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate 60 days from Start Date - including weekends
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 -- Rick (MVP - Excel) "Missy" wrote in message ... 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!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate 60 days from Start Date - including weekends
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" wrote in message ... 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!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate 60 days from Start Date - including weekends
THANK YOU THANK YOU!! So simple - sorry for the question!! :)
"JP Ronse" wrote: 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" wrote in message ... 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!! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate 60 days from Start Date - including weekends
You're welcome and we appreciate the feedback.
"Missy" wrote in message ... THANK YOU THANK YOU!! So simple - sorry for the question!! :) "JP Ronse" wrote: 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" wrote in message ... 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating number of days including the start and end date | Excel Discussion (Misc queries) | |||
Calculating number of days including the start and end date | Excel Discussion (Misc queries) | |||
Days between dates including start day and weekends | Excel Worksheet Functions | |||
Auto Fill days of the month (not including weekends) | Excel Worksheet Functions | |||
I want to count days between two dates including start date | Excel Worksheet Functions |