Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for adding days to a date excluding weekends and holidays? Jake via OfficeKB.com Excel Discussion (Misc queries) 3 May 20th 23 07:48 PM
Date/Time Difference Excluding Weekends & Holidays Paula D Excel Worksheet Functions 3 June 29th 12 11:15 PM
Calculate A Date Excluding Weekends And Holidays travelersway New Users to Excel 10 February 9th 12 08:34 PM
subtracting date and time formats excluding weekends Diane13 Excel Worksheet Functions 15 September 1st 09 03:07 AM
Calculate A Date Excluding Weekends And Holidays travelersway New Users to Excel 1 February 8th 06 09:56 PM


All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"