Calculating number of days

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

Question #1
What formula would I use to calculate the number of days
between two dates? i.e. the number of days between Feb.
28/04 and March 2/04 is 3 days. What formula do I use to
get that?

Question #2
What formula would I use now to pick the largest number
out of a list of numbers?
 
Dates are just a serial number so subtract them, = B1-A1

=MAX(A1:A100)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Connie!

First prob:
=B1-A1
Format General

Dates are serial numbers representing the number of days since
31-Dec-1899. So deducting the earliest from the latest gives the
number of days.

=Max(A1:A100)
Returns the largest.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Did you get an A on your homework?

: Thank you everyone. Connie
:
: >-----Original Message-----
: >Question #1
: >What formula would I use to calculate the number of days
: >between two dates? i.e. the number of days between Feb.
: >28/04 and March 2/04 is 3 days. What formula do I use to
: >get that?
: >
: >Question #2
: >What formula would I use now to pick the largest number
: >out of a list of numbers?
: >
: >.
: >
 
She hasn't had a chance to submit it yet!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
:)


: She hasn't had a chance to submit it yet!
:
: --
:
: HTH
:
: Bob Phillips
: ... looking out across Poole Harbour to the Purbecks
: (remove nothere from the email address if mailing direct)
:
: : > Did you get an A on your homework?
: >
: > : > : Thank you everyone. Connie
: > :
: > : >-----Original Message-----
: > : >Question #1
: > : >What formula would I use to calculate the number of days
: > : >between two dates? i.e. the number of days between Feb.
: > : >28/04 and March 2/04 is 3 days. What formula do I use to
: > : >get that?
: > : >
: > : >Question #2
: > : >What formula would I use now to pick the largest number
: > : >out of a list of numbers?
: > : >
: > : >.
: > : >
: >
: >
:
:
 
Back
Top