Subtract Dates

  • Thread starter Thread starter John Castle
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
Working With Dates in Excel 2
Excel Formula or equation 3
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Subtracting number of days excluding the weekend 2
Trailing 30 days sum calculation with excel 1
subtract times with a negative result 1
Workday Formula to include date 0

Back
Top