View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default How to calculate # of days

On Wed, 4 Mar 2009 11:06:05 -0800, Jonathan
wrote:

If I have an admission date and a discharge date, how can I write a formula
to calculate the number of days between the two dates?


With your two dates in cells A1 and B1 the following formula gives the
number of days:

=B1-A1

Hope this helps / Lars-Åke