Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula Excluding Weekends
Hello gang,
Looking for guidance on a desired formula that would reflect the following: Objective: Give consectuive dates per quarter(s) in column minus weekends. i.e. = Tues, Apr 01 Wed, Apr 02 (or desired date format) Parameters: 04/01/08 - 06/30/08 Result: Should only reflect work week days (holidays are okay to include) but skip weekends when drag/drop through the column. Can't seem to come up with an equation to get this to work right. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula Excluding Weekends
Try this:
if your starting date, 04/01/08, is entered in D1, enter the following formula in D2 =IF(WEEKDAY(D1+1,2)<6,D1+1,IF(WEEKDAY(D1+1,2)=6,D1 +3,"")) And then fill down -- Anne Murray "Dvinechild" wrote: Hello gang, Looking for guidance on a desired formula that would reflect the following: Objective: Give consectuive dates per quarter(s) in column minus weekends. i.e. = Tues, Apr 01 Wed, Apr 02 (or desired date format) Parameters: 04/01/08 - 06/30/08 Result: Should only reflect work week days (holidays are okay to include) but skip weekends when drag/drop through the column. Can't seem to come up with an equation to get this to work right. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula Excluding Weekends
You could use the WORKDAY() function from the ATP addin or if you don't want
to install that try: =A1+1+(WEEKDAY(A1+1,2)5)*2 with your start date in A1 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Dvinechild" wrote in message ... Hello gang, Looking for guidance on a desired formula that would reflect the following: Objective: Give consectuive dates per quarter(s) in column minus weekends. i.e. = Tues, Apr 01 Wed, Apr 02 (or desired date format) Parameters: 04/01/08 - 06/30/08 Result: Should only reflect work week days (holidays are okay to include) but skip weekends when drag/drop through the column. Can't seem to come up with an equation to get this to work right. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula Excluding Weekends
This works beautifully, thanks for the note.
"FinRazel" wrote: Try this: if your starting date, 04/01/08, is entered in D1, enter the following formula in D2 =IF(WEEKDAY(D1+1,2)<6,D1+1,IF(WEEKDAY(D1+1,2)=6,D1 +3,"")) And then fill down -- Anne Murray "Dvinechild" wrote: Hello gang, Looking for guidance on a desired formula that would reflect the following: Objective: Give consectuive dates per quarter(s) in column minus weekends. i.e. = Tues, Apr 01 Wed, Apr 02 (or desired date format) Parameters: 04/01/08 - 06/30/08 Result: Should only reflect work week days (holidays are okay to include) but skip weekends when drag/drop through the column. Can't seem to come up with an equation to get this to work right. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
Date/Time Difference Excluding Weekends & Holidays | Excel Worksheet Functions | |||
Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
subtracting date and time formats excluding weekends | Excel Worksheet Functions | |||
Calculate A Date Excluding Weekends And Holidays | New Users to Excel |