Define a 4 day work week

**teomi** · 07-19-2010, 07:15 PM

Is there a way to redefine a work week to be 4-day (Mon-Thurs.).

I need to calculate start and end dates based on a net amount of work days.

For instance, if the start date is 8/9/2010 and the 'job' will take 14 working days (based on a 4-day week) what will be the end date?

Thanks,
Eitan

**martindwilson** · 07-19-2010, 07:26 PM

use networkdays() but in the holidays list also put all the fridays (you might need to activate the analysis tool pak add in;tools add-ins check the box next to analysis toolpak click ok)

**daddylonglegs** · 07-19-2010, 07:30 PM

Excel 2010 has a WORKDAY.INTL function which allows you to customise the working week but in Excel 2003 you can use a formula like this

=SMALL(IF(WEEKDAY(A1+ROW(INDIRECT("1:"&B1*10)),2)<5,ROW(INDIRECT("1:"&B1*10))),B1)+A1

confirmed with CTRL+SHIFT+ENTER

where A1 has the start date and B1 the number of days to add