DOB/Age Cell Formula - Rounddown

[Paul1895]

Hi all!

I was wondering if someone could please give me hand with a, probably very simple, formula.

I am about to circulate a worksheet to a few organisations my my office deals with, asking them to enter some standard details of their clients (First Name, Surname, DOB, Age...). I have set up the "Age" column to be auto generated based on the date entered in the "DOB" column, but would also like to include a "ROUNDDOWN" function as well as an "IF DOB cell IS BLANK then leave AGE cell BLANK" function (see below for what i have now):


[TABLE="class: grid, width: 800, align: center"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]DOB[/TD]
[TD="align: center"]AGE[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD][/TD]
[TD]= IF ( A2 = " " , " " , ( TODAY ( ) - A2 ) / 365.25 )[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]28/08/1990[/TD]
[TD]29 (needs to be 28)[/TD]
[/TR]
</tbody>[/TABLE]


I would appreciate any assistance with this formula.

Thanks

Paul

 

[AlphaFrog]

Try this...

=DATEDIF(A2,TODAY(),"Y")

DATEDIF function

 

[Paul1895]

Great! Thanks for the quick response

Are you able to add the (if A2 is BLANK leave B2 BLANK) to the above mentioned formula?

Thanks again.

 

[AlphaFrog]

yes

=IF(A2="","",DATEDIF(A2,TODAY(),"Y"))

 

[Paul1895]

Perfect!

Thanks

 

[Vishaal]

its usefull