Days between 2 Dates

[Guest]

I want a fcn that gives the no. of days between 2 dates, like DAYS360 but exact. I tried making one using DATEVALUE but that doesn't accept cell references, only typed dates.

 

[Kevin Stecyk]

Hi Thor,

Please consult Chip Pearson's site for DateDif....

http://www.cpearson.com/excel/datedif.htm

Regards,
Kevin

I want a fcn that gives the no. of days between 2 dates, like DAYS360 but

exact. I tried making one using DATEVALUE but that doesn't accept cell
references, only typed dates.

 

[JMay]

A1 11/27/03
A2 11/15/03
A3 = A1-A2 displays -->> 15

I want a fcn that gives the no. of days between 2 dates, like DAYS360 but

exact. I tried making one using DATEVALUE but that doesn't accept cell
references, only typed dates.

 

[Chip Pearson]

Thor,

You can simply subtract one date from another, and format the
result as General or numeric, to return the number of days
between two dates.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I want a fcn that gives the no. of days between 2 dates, like

DAYS360 but exact. I tried making one using DATEVALUE but that
doesn't accept cell references, only typed dates.

 

[Gord Dibben]

-->> 15??

Tilt!<g>

Gord

A1 11/27/03
A2 11/15/03
A3 = A1-A2 displays -->> 15


exact. I tried making one using DATEVALUE but that doesn't accept cell
references, only typed dates.

 

[Thor]

Thanks, guys!

-----Original Message-----
Thor,

You can simply subtract one date from another, and format the
result as General or numeric, to return the number of days
between two dates.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


dates, like
DAYS360 but exact. I tried making one using DATEVALUE but that
doesn't accept cell references, only typed dates.


.