Year, Month and Date calculation.

[satishkumar123]

Hi Friends,

I want an excel formula to calculate the Resultant Year, month and days when manipulating with series of Year, Month and days.

Attached the sample excel.

Thanks
Satish.
satisheee [at] gmail [dot] com

 

[NARAYANK991]

Hi Satish ,

I have used a slightly different method.

Narayan

 

[Luke M]

Just for fun, another approach using the DAYS360 function.