Date calculation required please

dave_gray

New Member
Joined
Sep 16, 2003
Messages
11
Hi. What i need is a way to work out a date (dd/mm/yyyy).
For example. I have a current age of 25 (date of birth 01/01/1979)

What i need to do is have another cell which will show me the date
where age of 75yrs and 1month and 1day would be displayed (etc.)

Is there an easy way? I am a system tester and have to test a few
scenarios where rules and validation are called depending on birthdays
and the like.

Thanks for reading
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

In Cell A1 enter 1/1/1979 (the birthdate)
In Cell A2 enter 1/2/75

In Cell A3 enter this formula

=A2+A1

ALternatively

If C1 contains 25 (The Age then)

in D1 enter this formula

=("1/1/"&YEAR(TODAY())-C2)+A2

Either of these any use?
 

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

I must have mis-read the request, I thought the answere required was when the age of 75 years, 1 month and 1 day was required,

e.g.

Age 25 = Birthdate 01/01/1979. What I was doing was adding 75 years, 1 month and 1 day onto this date giving an answer of 02/02/2054.

What was required was 75 years on from the birthdate, giving an answer of 01/01/2054.

Sorry!

:oops: :oops:
 

dave_gray

New Member
Joined
Sep 16, 2003
Messages
11
Thanks gentlemen, I will work with these until i get it right.
Its difficult to explain but image you have a an age of say 20
and you want his date of birth worked out. But you also need the when he retires say 75 (what date is that going to be?)

Thanks guys
 

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

As i suspected you just wanted to know the date 75 years on from the birthdate, Aladins formula gives this answer (as usual).

Obviusly to get the exact day of retirement, you will need to know the birthdate.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,102
Messages
5,768,102
Members
425,454
Latest member
khoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top