Pet Age DATEDIF error on page

[thorrrr]

Hi Guys
I have a newbie query, i have a little sheet with my Pets ages using the DATEDIF function.
Excel keeps showing me errors in the formula but i cannot see what i am doing wrong any ideas welcome please

See images here

Pic 1 Sheet Pet Age Errors.png
Pic 2 Formulas Pet Age Forumulas.png


Or see sheet here https://skydrive.live.com/redir?page...E0nKrx-uLKQ19s

Or on another note is there a better way to work out the ages of my Pets?

[wenqq3]

Hi thorrrr, there link you provide no available. Please use forum function
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[Fotis1991]

Hi thorrrr, there link you provide no available. Please use forum function
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

+1 to this.

[thorrrr]

OK done it now

[Pepe Le Mokko]

Please post a sheet, not pictures -

[wenqq3]

DATEDIF( start_date, end_date, interval )
Y The number of complete years.
M The number of complete months.
D The number of days.
MD The difference between the days (months and years are ignored).
YM The difference between the months (days and years are ignored).
YD The difference between the days (years and dates are ignored).

Your should be C3 = DATEDIF($B3,TODAY(),"D")

[thorrrr]

Did you want this https://skydrive.live.com/redir?page...E0nKrx-uLKQ19s
Hi Wenqq3

Cheers mate changed it errors gone, i guess i have done it the best way?

Thorrrr

[Pepe Le Mokko]

Thanks for the effort - Mmebers mostly don't trust outside links - If you could post on the forum ( see FAQ) it would be easier for everyone

[thorrrr]

Thanks to everybody who helped and so fast