Calculate date - 1st of the month following 65th birthday - EXCEL

J

Joan

I am trying to calculate date: 1st of the month following 65th birthday.
Can calculate 65th BDay, Can calculate 1st of the month but cannot get it
combined

Thanks for your help
Joan
 
N

Niek Otten

Hi Joan,

=DATE(YEAR(A1)+65,MONTH(A1)+1,1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to calculate date: 1st of the month following 65th birthday.
| Can calculate 65th BDay, Can calculate 1st of the month but cannot get it
| combined
|
| Thanks for your help
| Joan
 
E

Elkar

Let's say your Date of Birth is in cell A1. Try this formula:

=DATE(YEAR(A1)+65,MONTH(A1)+1,1)

HTH,
Elkar
 

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

Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Mail Merge Help 1
monthly calculation for storage 0
Extra help on Nth Day of month 1
Display weeks from a Milestone 0
number of months and days between two dates without approximation 3
calculate future age date by birthdate 1

Top