View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default calculate date diff in a cell

Brian,

If I understand you correctly (and I probably don't)

in a1 you have a value: 2006/01/01
in a2 you have a value: 2006/01/03

in b2 for days difference: =A2-A1

Robin Hammond
www.enhanceddatasystems.com

"Brian Shafer" wrote in message
...
Hi.
I have a spread sheet that contains in the first column a date time
formatted field, in a few columns over, I have a field that I would like
to automatically calculate the days between the current rows date field
and the previous rows date field and put the number of days different in
the days diff column. Can anyone help me with this...?
Thanks,
Brian Shafer