View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jamesfc30@gmail.com is offline
external usenet poster
 
Posts: 3
Default Work Week, Excel 2000 & 2003

Hello,

Is there a way to modify Chip Person work day function so that it will
list First Workday of week and last work day of week.

For example:

Jan 7 - Jan 11 2008
Jan 14 - Jan 18 2008
Jan 21 - Jan 25 2008
Jan 28 - Feb 1 2008
Feb 4 - Feb 8 2008

=IF(OR(WEEKDAY(C4+1)=1,WEEKDAY(C4+1)=7),C4+3,C4+1)

Thank you for your help,
jfcby