Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate business Dates
Hello How do I calculate 4 business weeks from a given date Lets say four
business week from Friday March 2 2007 If the due date falls on a saturday or Sunday it should be due on Monday thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate business Dates
Define a Business week? I assume that you want to skip holidays. I think
you need to make a table of holidays. Then count the number of holidays of holidays in the 4 weeks period. Then add to the present date four weeks plus holidays. Then test if this date is on a saturday or sunday. Without Holidays andt the date in Microsoft time format. Make sure the cell with the formula is formated as a date =IF(WEEKDAY((A2+28),2)<=5,A2+28,IF(WEEKDAY(A2+28,2 )=6,A2+30,A2+29) ) "Wanna Learn" wrote: Hello How do I calculate 4 business weeks from a given date Lets say four business week from Friday March 2 2007 If the due date falls on a saturday or Sunday it should be due on Monday thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate business Dates
=NETWORKDAYS(start_date,4)
NETWORKDAYS is an Analysis Toolpak Function, so make sure that that is installed. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Wanna Learn" wrote in message ... Hello How do I calculate 4 business weeks from a given date Lets say four business week from Friday March 2 2007 If the due date falls on a saturday or Sunday it should be due on Monday thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate business Dates
Oops, taht should be 20 not 4.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Wanna Learn" wrote in message ... Hello How do I calculate 4 business weeks from a given date Lets say four business week from Friday March 2 2007 If the due date falls on a saturday or Sunday it should be due on Monday thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate the number of business days? | Excel Discussion (Misc queries) | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
Calculate Business without the use of the Add-In (Analysis Tool-Pak) | Excel Discussion (Misc queries) | |||
How do I calculate a cost/benefit ratio for a business proposal? | Excel Discussion (Misc queries) | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions |