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):
<tbody>
</tbody>
I would appreciate any assistance with this formula.
Thanks
Paul
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