How to calculate # of days

J

Jonathan

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?
 
L

Lars-Åke Aspelin

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?
Click to expand...

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

=B1-A1

Hope this helps / Lars-Åke
 
G

Gord Dibben

Not weird at all.

Serial number of Discharge date is greater than serial number of Admission
date.

March 4, 2009 serial is 39876

February 4, 2009 serial is 39848


Gord Dibben MS Excel MVP
 

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

Expanding Date Formula 0
Display weeks from a Milestone 0
Countdown macro - display settings 2
MS Project. Real progress of the project, % complete 1
Using an IIF Statement to calculate discharge date 4
Calculating days spent to complete a task 2
Month days over a time period 5
How to calculate difference between two date & time along with working hours and days 2

Top