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):

	A	B
1	DOB	AGE
2		= IF ( A2 = " " , " " , ( TODAY ( ) - A2 ) / 365.25 )
3	28/08/1990	29 (needs to be 28)

<tbody>
</tbody>

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