View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ghost ghost is offline
external usenet poster
 
Posts: 41
Default How to subtract two date Problem

Hi
I have a sheet to calculate the number of months between to date.
in A1 = 05/26/2007
B1 =06/26/2006
C1 = =DATEVALUE (B1-A1)
After that C1 shows me €śvalue€ť which is an error
Can any body help me solving this problem?
Thanks!!