G Guest Aug 28, 2006 #1 The task is blatantly basic ... but, nothing I've tried, to cure the #value! err, works ??
G Guest Aug 28, 2006 #2 Without more information, it seems like at least one of your "data" values is actually text. Does that help? *********** Regards, Ron XL2002, WinXP
Without more information, it seems like at least one of your "data" values is actually text. Does that help? *********** Regards, Ron XL2002, WinXP
R Richard Buttrey Aug 28, 2006 #3 The task is blatantly basic ... but, nothing I've tried, to cure the #value! err, works ?? Click to expand... Is the Morefunc add-in loaded? HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________
The task is blatantly basic ... but, nothing I've tried, to cure the #value! err, works ?? Click to expand... Is the Morefunc add-in loaded? HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________
G Guest Aug 28, 2006 #4 hi, =datedif(a2,a1,"d") a2 must have the previous date, and DateDiff (with two f's) is to VB not normal formulas. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Boswell" escreveu:
hi, =datedif(a2,a1,"d") a2 must have the previous date, and DateDiff (with two f's) is to VB not normal formulas. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Boswell" escreveu:
