Calculating birthday - yet another newcomer!!

A

Alberte

Hi there

I've been trying to use =DATEDIF(A1,TODAY(),"y") - A1 being my date of
birth, but when I activate the formel I get an error - high-lighting both the
A1 and TODAY - I'm a Danish user and the excel I'm using is in Danish vers.
2003 - does that have anything to do with it??? And what cell format do I
need to use in A1 - 'standard' is my first choice but I still get an error!!!

Regards
Alberte
 
D

daddylonglegs

hello Alberte,

you may have to use semi-colons instead of commas, try


=DATEDIF(A1;TODAY();"y")

format as general
 
S

Stefi

Select result cell
Open Tools/Macro/Visual Basic editor/View/Immediate window
Type in activecell.Formula="=DATEDIF(A2,TODAY(),""Y"")"
Press enter

Excel will translate the English formula into Danish.

Regards,
Stefi




„Alberte†ezt írta:
 
A

Alberte

YES! that did it - both the translation to danish in the formel and the
semicolon, the result is:

=DATO.FORSKEL(B2;IDAG();"y") - where B2 is my date of birth

Thanks! :)

"Teethless mama" skrev:
 
Top