Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
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. "J-To" wrote: 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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
US dates to UK?? | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |