How do I keep day field no higher than 1st of the month when usin.

G

Guest

I am trying to figure the retirement date for individuals. If DOB is
6/25/1928 than retirement would be Acutal Retirement date of 07/01/1990, not
DOB Retirement Date of 6/25/1990. I cannot get a formula to give me the
correct response. The formula I have adds 62 years exactly to the date, not
moving it to the next month. Does anyone know how I can set up the cell so it
does not go over the 1st of the month following the DOB Retirement Date?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO FIND DIFF. BETW. 2 DATES, IT SHOULD BE IN YRS, MONTH & DAY 3
How do I calculate age using a 12 digit social security number in MS Excel? 0
Default Value of field based on another field of same record 5
Formula to Return the next 1st Tuesday of a Month 42
First working day of the month 2
Rounding date field up to next first of month, with existing formu 5
Return mm/dd/yy based on 1st Day of Month 5
Listing only the workdays of a month 4

Top