Difference between two dates

  • Thread starter Thread starter tc
  • Start date Start date
T

tc

hi. i need to create a macro that will alow me to find the difference
in days between two given dates. is this possible?
thanks
 
if the dates are in A1 and B1, then

=MAX(A1,B1)-MIN(A1,B1)
 
Just subtract them

Dim Date1 as date
dim Date2 as date

date1 = dateserial(2007,12,25)
date2 = dateserial(2008,1,13)

msgbox date2 - date1 '+ 1

Is the 3rd - 1st a difference of 3 days or 2 days?
 
Why not just this...

=ABS(B1-A1)

instead?

Rick
 
You must log in or register to reply here.

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

Date subtraction 1
Pivot table macro filter data between yesterday and today (date+time) 0
The difference between two dates. 6
Macro to convert date to text 3
Calc Number of Months PER YEAR Between Dates 2
Subtracting AD and/or BC dates 21
Calculating Test Score Averages 6
Find Date between two dates 1

Back
Top