Using the Workday function

Hi,

I need help using the workday function. My problem is this. I have either a fixed date or variable date in column D i.e. 10/30/06, # of days in column F, and due date in column H. How can I calculate the due date excluding weekends and holidays? Also, the number of days in column F will vary.

Thanks,

marty6

Hi go to this site http://www.lacher.com/examples/lacher39.htm and download the free sample it shows the calculations taking in to account weekends, it also shows a calculation for finding the number of days worked!

Regards,
Simon

It depends if your due date includes or excludes weekends for the purposes of 'days taken' or includes weekends other than the return date.

ie borrow monday 2 Jan for 12 days could be due back on Sat 14 Jan if every day counts, then adjust the date to the following monday, or it will be due back on Wed 18 if only weekday counts.

If I assume the former, just do a formula like this.

=if(weekday(borrow date + days borrowed)=7,(borrow date + days borrowed)+2,if(weekday(borrow date + days borrowed)=1,(borrow date + days borrowed)+1,(borrow date + days borrowed))

ie if the return date is a Sat, add 2 days, if it is Sun, add 1 day, else just use the calculated day

Matt