View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dvinechild Dvinechild is offline
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.