View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Malik Malik is offline
external usenet poster
 
Posts: 47
Default Subtracting Dates

Hi,

how do I subtract the dates? I have a date in one cell and a date in
another. i wish to know the difference with respect to the number of days
between the two dates. wt formula shud b used in the next cell? Simply
applying the formula =A1-A2 gives me an absurd date in A3? i need the no of
days.
thx for help.