View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default (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