W
Windchaser
This problem is driving me nuts! The following Excel formula works fine in
several workbooks, but in one particular worksheet it generates the # VALUE
! error. Of course this is the one I really want it to work in. Any
suggestions of what I could be doing wrong?
=DATEDIF(15487,TODAY(),"y")&" Yrs, "&DATEDIF(15487,TODAY(),"ym")&" Mnths,
"&DATEDIF(15487,TODAY(),"md")&" Dys"
Windows XP Service Pack 1, Excel 2002.
Thank you for saving my sanity.
several workbooks, but in one particular worksheet it generates the # VALUE
! error. Of course this is the one I really want it to work in. Any
suggestions of what I could be doing wrong?
=DATEDIF(15487,TODAY(),"y")&" Yrs, "&DATEDIF(15487,TODAY(),"ym")&" Mnths,
"&DATEDIF(15487,TODAY(),"md")&" Dys"
Windows XP Service Pack 1, Excel 2002.
Thank you for saving my sanity.