View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Counting days between 2 dates

Just subtract

=later-earlier

of course you need to add 1 to that formula to get 31


--


Regards,


Peo Sjoblom

"cockatoo" wrote in message
...
Is there a formula for calculating the number of days between two dates
e.g.
1/1/09 and 1/31/09 = 31 days