calculate retirement date in excel
Find herewith an attachment of my workbook I am trying to working out the calculation of date of retirement in column F2 and F3, the default age is 58 years in reference to date of birth in column D2 and D3. But I could not work the calculation with the mentioned logic.
Pls help at the earliest.
In F2
=D2+(365.25*58)
Copy down
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
try attachment
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Try this,
F2, copy down.
=EOMONTH(D2,58*12-(DAY(D2)=1))
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks