Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I posted this question a few weeks back and the answer I received, while greatly appreciated, did not work for me so I thought I'd try once more. I have created a spreadsheet to show two dates (date of birth, retirement date). I need to calculate how old the person is on their date of retirement (in years and months). So what I've done is created two columns, one for years and one for months (e.g. the person is 59 years and 8 months old). Here is where it gets complicated. If the person is born on the 14th of the month of before, then that month is NOT counted in their age. If they are born on the 15th of the month of later, then that month IS counted in their age. Any help that could be provided would be GREATLY appreciated. Thanks very much, Teri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
date calculations | New Users to Excel | |||
Date Calculations | Excel Discussion (Misc queries) | |||
Date Calculations before date entered | Excel Discussion (Misc queries) | |||
Date calculations and sum | Excel Worksheet Functions | |||
Date Calculations | Excel Worksheet Functions |