Calendar days from start date and workdays

Hi,

This may be a really simple question but I just can't think....

If I have a start date say 01/08/2010

And the workdays was 35

how can I get the calendar days.

The answer should be 20/09/2010

Hi Ron,

To expand further if I have the start date say 01/08/2010 and I have the number of working days say 21, how can I get the number of calendar days. The previous formula does work, but I am having issues in that not every date and length combination returns the correct result.

My spreadsheet does this process a maximum of 3 times for full, half and nil pay depending on the individuals allowance and the length of their leave. I have the correct work day duration and calendar days at the top, but that is simple as the start and end date is absolute.

The spreadsheet then calculates whether this is full, half or nil pay or a combination of 2 or 3 of them and then produces lines with based on the allowance of of occupational sick days the have remaining.

For Example if you had 20 days full 20 days half allowance

and you went off sick from the 20/09/10 to the 29/10/10 (30 working days)

Your lines would look like this:

Please Login or Register  to view this content.

How it works is that it currently pulls the start date in for the first line which is determined by the remaining allowance, it then calculates how many work days are associated with this line. The tricky and not so accurate bit at the moment is then working out the end date from a start date and number of work days and getting an accurate number of working days.

I have observed errors such as 3 days after the end date being put in for the end date on the last line or the calendar days being a day out in total to the calendars calculated where you key in the start and end date.