Subtract Dates

J

John Castle

How do I subtract one date from another to get the number
of days they are apart? eg subtract 26 March from 10th May
to get 45 days? I know there is a function in access to do
this, but can it be done in Excel
 
N

Norman Harker

Hi John!

=B1-A1
Format General

Note that dates are serial numbers which represent the number of days
since 31-Dec-1899; hence the ability to deduct one from the other to
get the number of days between.
 
Top