Thread: how do I subtract 2 date fields to get number of days elapsed?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Forbes Andrew Forbes is offline
external usenet poster
  
Posts: 1
Default how do I subtract 2 date fields to get number of days elapsed?
I need to calculate the difference between date fields to get the answer in
days

E.g. Open shop 10 Feb 2004
close shop 15 feb 2004
= 5 days

So what is the formula for this???

Reply With QuoteReply With Quote