Date Formulae?

[midfieldgeneral11]

Good afternoon

Can you help?

Simple formulae I would like to be able to do a formulae regarding age.

I have a field named Date of Birth all I want to do is simply give me the age of the person in another field.

So example

Field A Name: John Smith
Field B Date of Birth : 07/03/1974

Field C I want this to bring back 37

Can you help.

I would like to keep the spreadsheet ROLLING so this is constantly updating from today’s date…

Can you help?
Thanks for looking.....
Simon

 

[VoG]

Try

=DATEDIF(B1,TODAY(),"y")

 

[Yahya]

you can use also
=YEARFRAC(start_date,end_date,basis)

 

[midfieldgeneral11]

Sorry forgot one thing!!! You were hot off the blocks then!!!

Can we include if the Field has not got a date in the field and is BLANK please just BLANK as this comes back with #value?

Is that ok?

 

[VoG]

It shouldn't come back as #Value, it should come back as 111. Make sure the "blank" cell is really blank then try

=IF(B1="","",DATEDIF(B1,TODAY(),"y"))

 

[midfieldgeneral11]

Works like a dream!!!

You would not know what to suggest on this thread?

http://www.mrexcel.com/forum/showthread.php?t=565259

 

[Xtrimmer]

I am a bit confused about the difference between YEARFRAC and DATEDIF and am curious as to what it is. For the start date being 1/1/2011, and the end date being 12/31/2011, if I use =YEARFRAC(start_date,end_date,basis) the formulae returns 1 while =DATEDIF(start_date,end_date,"y") returns 0, but for the dates 1/1/2011 and 1/1/2012, both formulas return 1. I would think that the first set of dates with the YEARFRAC function should return a decimal of approximately .99726 since 1 whole year has not quite passed. Any ideas as to why this might be?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
PS (the basis I used with YEARFRAC was the default of 0. I am only assuming that basis is the appropriate value to use here in the USA based on its description)<o></o>