| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to caluclate the # of years and months between two dates
This is a simple formula that gets years months and days, adjust as needed
=YEAR(B4)-YEAR(A4) & " years " & MONTH(B4)-MONTH(A4) & " months " & DAY(B4)-DAY(A4) & " days" A4 has the current date and A4 has begin date "Christyepd" wrote: I am setting up the employees lenths of service from the date hired until present date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
| formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
| formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
| Formula that will represent years & months worked | Excel Discussion (Misc queries) | |||
| How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
