Days between 2 Dates

T

Thor

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.
 
J

JMay

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

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

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


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

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

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.


.
Click to expand...
 

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
Another Formula 3
How to change date format to 7 working days a week in ms project 2010? 0
Conditional Formatting - Cannot get it to work, please help 1
Adding values that fall between 2 dates 3
List all tables, including document structure 0
Mail Merge skipping records/sending one at a time 0
Formula to tell day of week 3

Top