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.

Ad

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

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Posted on Jan 31, 2009

Ad

Convert the dates to Julian format using the online Naval Observatory calculator. Subtract and divide by 7. Round up. 2456880.5 minus 2455616.5 = 1264 days or 180.57 weeks. Use 181

http://aa.usno.navy.mil/data/docs/JulianDate.php

http://aa.usno.navy.mil/data/docs/JulianDate.php

Oct 05, 2014 | Computers & Internet

From page 31 of the manual in English, available on HP's website at the link below:

**Number of Days Between Dates **

To calculate the number of days between two given dates:

1. Key in the earlier date and press [ENTER].

2. Key in the later date and press [g][?DYS].

The answer shown in the display is the actual number of days between the two dates, including leap days (the extra days occurring in leap years), if any. In addition, the hp 12c also calculates the number of days between the two dates on the basis of a 30-day month. This answer is held inside the calculator; to display it,

press [X><Y]. Pressing [X><Y]again will return the original answer to the display.

http://www.hp.com/ctg/Manual/c00363319.pdf

To calculate the number of days between two given dates:

1. Key in the earlier date and press [ENTER].

2. Key in the later date and press [g][?DYS].

The answer shown in the display is the actual number of days between the two dates, including leap days (the extra days occurring in leap years), if any. In addition, the hp 12c also calculates the number of days between the two dates on the basis of a 30-day month. This answer is held inside the calculator; to display it,

press [X><Y]. Pressing [X><Y]again will return the original answer to the display.

http://www.hp.com/ctg/Manual/c00363319.pdf

Sep 26, 2014 | HP 12c Calculator

If the Canon MP11DX has a backup battery, it may be spent, and it should be replaced with a fresh one.

Oct 11, 2013 | Casio FX991MS Scientific Calculator

You could do a simple +NOW-START DATE

It would depend on the format of your start dates - i.e YY, DD/MM/YY as to the results you get.

Do want the results in years, months, days?

It would depend on the format of your start dates - i.e YY, DD/MM/YY as to the results you get.

Do want the results in years, months, days?

Jun 05, 2009 | Microsoft Excel for PC

not sure if this is what you are after entirely but should at least help you out some what

=DATEDIF(A3,C3,"m")/3

As you said you cant just divide by 3 but I have divided the formula by 3 to see how many 3 months will go into the output you could maybe have another formula to divide it by 2 to see if it will divide by 2 to see if you get a whole number or not, if you do then you can just return the first part before the dot ( using split function ) and if the value is less then 1 then obviously the 3 months has not passed between the 2 dates

=DATEDIF(A3,C3,"m")/3

As you said you cant just divide by 3 but I have divided the formula by 3 to see how many 3 months will go into the output you could maybe have another formula to divide it by 2 to see if it will divide by 2 to see if you get a whole number or not, if you do then you can just return the first part before the dot ( using split function ) and if the value is less then 1 then obviously the 3 months has not passed between the 2 dates

May 09, 2009 | Microsoft Office Excel 2003 for PC

Hi,

Without looking at your books, I can only hazard a few guesses. One is that the person is salaried and by pay date the calculation is figuring on an extra payweek. There are 53 Sun, Mon, Tue and Wednesdays in this year. Check the math and see if that is the problem (to correct add an extra pay week into the salaried amount in the employee profile)

Without looking at your books, I can only hazard a few guesses. One is that the person is salaried and by pay date the calculation is figuring on an extra payweek. There are 53 Sun, Mon, Tue and Wednesdays in this year. Check the math and see if that is the problem (to correct add an extra pay week into the salaried amount in the employee profile)

Jan 07, 2009 | Intuit QuickBooks Pro 2003 Single User...

There is no function to do this as part of a whole suite of date manipulation functions, but I seem to have imagined that, as I couldn’t find. I was dreading having to do lots of nasty date arithmetic, but then I discovered that the zeroth day of a month is treated as the last day of the previous month! So the last day of the month for the date that’s in cell B3 is simply:

=DATE(YEAR(B3), MONTH(B3)+1, 0)

It even works across year boundaries, so DATE(2004, 13, 0) really does give

=DATE(YEAR(B3), MONTH(B3)+1, 0)

It even works across year boundaries, so DATE(2004, 13, 0) really does give

Mar 11, 2008 | Computers & Internet

The eomoth function returns the last day of the month.

Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

eomonth (1/2/08, 1) will return 31. The number of days in the month.

eomonth (1/2/08, 2) will return 59, The number of days in the month plus the next month (February)

Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

eomonth (1/2/08, 1) will return 31. The number of days in the month.

eomonth (1/2/08, 2) will return 59, The number of days in the month plus the next month (February)

Mar 06, 2008 | Microsoft Excel for PC

Hi,
I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula.
However here are some tips:
Set up a column with the start date for each employee and use the today() function to get today's date.
You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month.
For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together.
Good luck
K

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!

×