| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a formula that will subtract todays date from a hire date
Try this:
A1 = hire date =DATEDIF(A1,NOW(),"y") -- Biff Microsoft Excel MVP "Heather" wrote in message ... is there a formula that will subtract todays date from a hire date so that I could have a "years of service" column |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract one year from todays date | Excel Discussion (Misc queries) | |||
| Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
| formula for lenght of employment based on hire date | Excel Worksheet Functions | |||
| Formula to subtract a date from current date | Excel Worksheet Functions | |||
| todays date formula | Excel Worksheet Functions | |||
Threaded Mode
