Calculating birthday - yet another newcomer!!

[Guest]

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

 

[Don Guillett]

Worked for me in English. Try with ; instead of ,

 

[Guest]

hello Alberte,

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


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

format as general

 

[Guest]

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:

 

[Guest]

DATO.FORSKEL (for Danish version)

 

[Guest]

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:

 

[Guest]

You are welcome! thanks for the feedback!
Stefi


„Alberte†ezt írta: