Excel - Calculate Return Date - Working Days only 1

[Livia8]

Hi there,

I'm trying to set up a spreadsheet to calculate employee return dates:

On cell A1 I've the start date of the absence; on Cell B1 I've the number of weeks; on cell C1 I've the number of days per week; on cell D1 I've the total (C1*D1); on cell E1 I've the return date (D1+A1), but this includes weekends;

On F1 I'd like to have a formula that shows the next working day (i.e. the day when the employee is due to return to work); also, on cell G1 I've the number of bank holidays which occurred during the absence, and these would have to be added to F1 too, but H1 should show once again the return date taking into account that the weekends should not be added (Let's say a person is due back on a Friday, if they have 1 bank holiday then the return date should be Monday, not Saturday).

Thanks in advance.

 

[AnotherHiggins]

See the WORKDAY function. =WorkDay(StartDate, Days, [Holidays])

Holidays is an option argument. If you want, you could have a list of known holidays elsewhere in the workbook and refer to that range.


You'll need to have the Analysis ToolPak add-in installed.

If the function returns a #NAME? error, go to Tools > Add-Ins and check the box beside Analysis ToolPak.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Livia8]

Thanks John,

That worked very well.

Thanks again,

Livia