Question about Microsoft Excel for PC

# Converting date of a month to last working day of the month

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.

Posted by on

### Anonymous

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Governor:

An expert whose answer gotĀ voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

• Expert

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

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### How do I calculate Total number of weeks merchandise has been in stores give first receipt date & last receipt date exampl

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

Oct 05, 2014 | Computers & Internet

### How do i get change in days

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

Sep 26, 2014 | HP 12c Calculator

### Need a formula to calculate length of service in excel

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?

Jun 05, 2009 | Microsoft Excel for PC

### Calculate Quarters between any two dates

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

May 09, 2009 | Microsoft Office Excel 2003 for PC

### Create a class called Date in C++

I wrote it for you:
date.cpp
date.h
Remember, this is only a demonstration, so you can learn from it!

Mar 26, 2009 | Computers & Internet

### QuickBooks 2003 Payroll Question

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)

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

### Access

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

Mar 11, 2008 | Computers & Internet

### Functions

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)

Mar 06, 2008 | Microsoft Excel for PC

### Creating a holiday accrual spreadsheet.

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

## Open Questions:

#### Related Topics:

264 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert