when will someone turn 15 and a half

[ama299]

Is there a way in excel or access

that will display the date when someone turns 15 and a half

 

[SkipVought]

Hi,

WHAT?

Do you want to surprise your 15 1/2 year old son or daughter?

How do we know how old they are?

=DATE(YEAR(Birthdate)+15,MONTH(Birthdate)+6,(DAY(Birthdate)))

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ama299]

Students are suppose get paperwork for drivers ed when they turn 15 and a helf

Thanks for the info

 

[tav1035]

ama299,
To calculate a persons age based on their birthday and todays date.

(A1) Birth date : (B1) 16-Dec-68

(A3) Years lived : (B3) 34 =DATEDIF(B1,TODAY(),"y&quot
(A4) Months : (B4) 10 =DATEDIF(B1,TODAY(),"ym&quot
(A5) Days : (B5) 0 =DATEDIF(B1,TODAY(),"md&quot


Tav's age is 34 Years, 10 Months and 0 Days
Formula is->
="Tav's age is "&DATEDIF(B1,TODAY(),"y&quot&" Years, "&DATEDIF(B1,TODAY(),"ym&quot&" Months and "&DATEDIF(B1,TODAY(),"md&quot&" Days"

Hope this helps...
tav

 

[tav1035]

Skip,
I can't get the right date.
Whats the format of the date in your formula?
ie. =DATE(YEAR(12/16/1968)+15,MONTH(12/16/1968)+6,(DAY(12/16/1968)))
or
=DATE(YEAR(1968)+15,MONTH(12)+6,(DAY(16)))
Not sure how to use it?

I can get it to work like this->
=DATE(YEAR(A1)+15,MONTH(A1)+6,DAY(A1))
Assuming that your birthday is in "A1"
tav

 

[SkipVought]

Tav

=YEAR(AnyDate)

returns the year from a date serial number

So if You enter a date in a cell named Birthdate

=DATE(YEAR(Birthdate)+15,MONTH(Birthdate)+6,(DAY(Birthdate)))

returns the date 15 years and 6 months later.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[tav1035]

Thanks Skip,
I was missing one important part-> "You enter a date in a cell named Birthdate" and leave the formula exactly how you wrote it.
Works now,
tav

 

[Shelbyville]

Nothing to do with formulas or Excel but I'd be very surprised if you had to REMIND any student that they could take Driver's Ed, and as a result be that much closer to a driver's license.

 

[SkipVought]

AMEN! Shelbyville

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com