ExcelBanter - (date diff.) A2-A1=#value! ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - (date diff.) A2-A1=#value! ? (https://www.excelbanter.com/excel-worksheet-functions/107366-date-diff-a2-a1%3D-value.html)

Boswell

(date diff.) A2-A1=#value! ?

The task is blatantly basic ... but, nothing I've tried, to cure the #value!
err, works ??
--
Boswell

Ron Coderre

(date diff.) A2-A1=#value! ?

Without more information, it seems like at least one of your "data" values is
actually text.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"Boswell" wrote:

The task is blatantly basic ... but, nothing I've tried, to cure the #value!
err, works ??
--
Boswell

Richard Buttrey

(date diff.) A2-A1=#value! ?

On Mon, 28 Aug 2006 05:52:02 -0700, Boswell
wrote:

The task is blatantly basic ... but, nothing I've tried, to cure the #value!
err, works ??

Is the Morefunc add-in loaded?

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Marcelo

(date diff.) A2-A1=#value! ?

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:

The task is blatantly basic ... but, nothing I've tried, to cure the #value!
err, works ??
--
Boswell

All times are GMT +1. The time now is 07:43 AM.