Hello,
I am trying to find a formula which will show the date of a potential student on a certain date e.g 1st August 2014
Cell A2 has the students date of birth
Cell B2 has the students current age
I would like cell C2 to show the students date of birth on the 1st August 2014.
Any help appreciated
Thanks
Quick way of doing this
A2 = DOB
B2 = Future year
=INT((B2-A2)/365)
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
=int(yearfrac(a2,datevalue("01/08/"&b2)))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
You meanOriginally Posted by Special-K
=INT(YEARFRAC(A2,DATEVALUE("08/01/2014")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks