Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2006

Tip: Looking for answers? Try searching our database.

DATEIF function help pleeeeeease

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JjL - 19 Mar 2006 01:49 GMT
first off let me state im a beginner... :)

basically i cant get this dateif thing to work out the yearly age o
someone...it seems fairly simple to me but i cant quite get it working
Well i cant get it working at all, i just keep getting #VALUE! haha...

I have a cell with =TODAY() which has been named 'Today'
Cell D4 contains the birthdate

Would i not just enter into any cell:
=DATEDIF(D4,Today,"Y")

And this would bring up the Yearly age of the person?

..Im thinking that the problem could lie within my formatting of th
cell? (it is set to *dd/mm/yyyy) But after much trial and error i
still getting no result.

I need this working for tomorrow as it is part of my AS Level projec
at school so any help of any sort would be much appreciated!

Thank you,

Jj :
Peo Sjoblom - 19 Mar 2006 01:56 GMT
If you get value error it's because the dob is text, make sure it is a
number and it will work
Format D4 as date, then type in a date and you'll see it will work

Signature

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

> first off let me state im a beginner... :)
>
[quoted text clipped - 20 lines]
>
> Jj :)
JjL - 19 Mar 2006 02:11 GMT
Fantastic!

I didnt expect such a punctual response, i'm very appreciative
thanks..
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.