Dates

[Guest]

Hello. I need to set up a spreadsheet with dates. I need to have a start
date minus the current date = the time in year/month. I need to calculate
something like this, it may be easier to start with the current date and
subtract the start date.
10/01/04 - 01/01/06 = 1.4 or 01/01/06 - 10/01/04 = 1.4
Please help with any ideas, I just need a simple spreadsheet. Thanks!

 

[Niek Otten]

http://www.cpearson.com/excel/datetime.htm#AddingDates

 

[Guest]

Try this... current date minus start date divided by 365 with the cell
formatted to 2 decimal places. So, if you had 10/01/04 in A1 and 01/01/06 in
B1 then you would type =(B1-A1)/365 and you would get 1.25 or one and a
quarter years.