Converting a Date into a number consisting of the number of full months and a percentage of the partial month

[Austin-L]

Hello, the title pretty much says it all! I am trying to convert an excel spreadsheet for income calculation for my boss. She wants me to convert a date format into a number format consisting of the total number of full months year to date, and the percentage of the number of days in the current month divided by the total number of days in the month (rounded up to 2 decimal places). --- For example: 8/16/2013 should read as 7.52 -- 2/5/2013 should read as 1.18 --- 11/11/2013 should read as 10.37. Thank you for your help!

 

[Matty]

I just tested it and it looks like it is working as expected. If I enter 8/1/2013 in box G11, G12 returns 7.03 which is the desired result. If I enter 8/31/2013, G12 returns 8.00 which is also working fine.

Good. Just wanted to be sure that was the behaviour you were expecting.

Matty