I wanted to manipulate dates in Microsoft Excel - the result is a sum of date, a fixed number of days and a variable no of day(s) from a second column.

I couldn't find much documentation in Microsoft Excel to help me. So I thought this maybe useful to some of you.

I essence I was trying to calculate the payment dates to the nurse who charges after every 10th working day. So for example if she takes a day-off then she charges on the 11th day.

Manipulating date is child's play in Excel. Just add / subtract them arithmetically. For example in my case the formula was: =A3+9+C3. This added A3 with 9 and C3 and returned the result as a date.

If the date is not formatted in the default format: mm/dd/yy then select the whole column and change it to appropriate format.