I have a date calculator attached. I need to make this date calculator count saturday or sunday as a working day if the open date and reopened date falls on a saturday or sunday otherwise it doesnt include the weekends.

At the moment to find the appropriate dates i need to enter the open date and close date to calculate the letter dates even if the complaint is still open( i just enter the close dates as the same date as the open). is there anyway around this as it is a slight annoyance.

I'll try and explain better once i get home but any help in the mean time is appreciated.

Thanks

backupdatecalc.xls