DATEDIF question

[LESSLIE COLLINS]

I need to calculate the difference in years, months & days between two
dates.

I have modified this "Find the age from date of birth to now" formula I
found on several Excel sites.

=DATEDIF(C6,C8,"y") & " years, " & DATEDIF(C6,C8,"ym") & " months, " &
DATEDIF(C6,C8,"md") & " days"

where C6 and C8 are the two dates.

but I get a #VALUE! result.

Any help would be appreciated.

--
Regards

Roy Collins
OzCollins.com
Disclaimer: The information contained in this e-mail message may be
confidential, and may also be the subject of privilege or public interest
immunity. This e-mail and any attached files should be scanned to detect
viruses and no liability for loss or damage resulting from the use of any
attached files is accepted. If you are not the intended recipient, any use,
disclosure or reproduction of this document is unauthorised. If you have
received this e-mail in error please telephone +61 8 8326 3970.

 

[Chip Pearson]

Lesslie,

You'll get a #VALUE error if one or both of the dates is a text string.
Ensure that both cells contain valid date values and that C6 is equal to or
less than C8.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Peo Sjoblom]

The only way I can reproduce that is if any of the cells are text..

 

[L. Roy Collins]

Thanks Chip,

Bye the way the RANK example on your site has come in very handy for me, not
the least in my work's footy pool.

--
Regards

Roy Collins
OzCollins.com
Disclaimer: The information contained in this e-mail message may be
confidential, and may also be the subject of privilege or public interest
immunity. This e-mail and any attached files should be scanned to detect
viruses and no liability for loss or damage resulting from the use of any
attached files is accepted. If you are not the intended recipient, any use,
disclosure or reproduction of this document is unauthorised. If you have
received this e-mail in error please telephone +61 8 8326 3970.