Need Help With A Formula . .

[Evagrius Ponticus]

Hello,

My Fiscal Year begins in October. In a cell A1 I ask the user for the date of the purchase of an Asset. Lets say the user enters 11/30/2010.

In anther cell A2 I ask the user for the FISCAL YEAR purchase of the asset as well as the ratio of months that have passed in the fiscal year over the the full year.

So, for example, in the above sample, the fiscal year would be 2011. Therefore in cell A2 the user would enter 2011.16. The .16 represents 2 months devided by 12 month, or 2/12 since two month have passed in the fiscal year.

I am now trying to create a formula for cell A2 - but can't seem to get it quite right. Thank you for any help!

 

[barry houdini]

.....But will you please share why you added the 1900.25?

YEARFRAC does what the name suggests, it returns the difference between 2 dates as a fraction of a year, so my suggested formula returns the difference between 0 and the date in A1....because 0 in Excel dates is 1900 you have to add 1900 to get the correct result, assuming that each year starts on 1st Jan.......but as your year starts 3 months early that's an additional ¼ to add...or 0.25