Calculation between dates

[Frankie needs HELP]

Help! I've got two columns of dates, the first is the registered date and the second is the admitted date. I need to find out the amount of days between them (the difference).

I've tried using the function DAYS360 but this miss calulates obviously because I need 365 days. I've also found DATEDIF but I can't figure out how to use it. HELP!
This message was edited by Frankie needs HELP on 2002-04-04 11:09

 

[Mark W.]

On 2002-04-04 11:07, Frankie needs HELP wrote:
Help! I've got two columns of dates, the first is the registered date and the second is the admitted date. I need to find out the amount of days between them in days(the difference).

I've tried using the function DAYS360 but this miss calulates obviously because I need 365 days. I've also found DATEDIF but I can't figure out how to use it. HELP!

Subtract the earlier date from the later...

=B2-A2

 

[kmiles]

Just subtract one date from the other - make sure the formula cell is formatted as number type with no decimals.

 

[Legacy 98055]

If registered date is in A1
If Admitted date is in B1

C1=B1-A1

Make sure format is general...

Tom