Excel - how to calculate date based on years in decimal

Hamster · 24 Sep 2014 at 20:19

I've made a little calculator that works out how many years worth of a product I have. It gives me the answer in decimal, so for example I have 2.37 years worth of product left.

Is there a formula that will use the current date and calculate the date the product will expire?

Thanks

413x · 24 Sep 2014 at 20:30

=today()+(2.37*365)

assume cell A1 is your decimal year

=today()+(A1*365)

will ignore leap years though
basically adds 365*product time to expire. Excel when using date format uses 01/01/1900 as '1' and 02/01/1900 as '2' etc etc

today() is your windows OS current date in this numerical format

Hamster · 24 Sep 2014 at 21:38

Thanks but i'm a bit lost. If i try the formula in your first line, the cell displays 42771.05

What am i missing?!

mangobreeder · 24 Sep 2014 at 21:52

change it to date format

Hamster · 24 Sep 2014 at 21:57

mangobreeder said:
change it to date format

doh, thanks

and thanks again al4x! It's now working well

413x · 26 Sep 2014 at 21:05

Good stuff. Yeah sorry. Forgot about the date format.

Hamster · 27 Sep 2014 at 20:08

al4x said:
Good stuff. Yeah sorry. Forgot about the date format.

No worries. Got it working fairly swiftly. Thanks again