Question about Microsoft Excel for PC
I want to calculate date of retirement of some staff members. But the problem is that it is calculating date of retirement from date of birth by adding either 60 years or 58 years as the case may be. But the date remains the same as given in the date of birth of the person. I want to make the date to be the last working day of the month. Please help.
Use the below formula to get the date of the LWD (Monday thru Friday) of the month.
Assumed that if the date in cell A1 is 6-May-2005. then formula will be
Posted on Jan 31, 2009
Tips for a great answer:
Oct 05, 2014 | Computers & Internet
Sep 26, 2014 | HP 12c Calculator
Oct 11, 2013 | Casio FX991MS Scientific Calculator
Jun 05, 2009 | Microsoft Excel for PC
May 09, 2009 | Microsoft Office Excel 2003 for PC
Jan 07, 2009 | Intuit QuickBooks Pro 2003 Single User...
Mar 11, 2008 | Computers & Internet
Mar 06, 2008 | Microsoft Excel for PC
Sep 05, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
264 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: