View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Finding the amount of days between two dates.

Maybe

datefrom = #4/1/2008#
dateto = #4/4/2008#
diffference = dateto - datefrom + 1

Mike

"NateBuckley" wrote:

Greetings, I'm sure the solution to this, is easier than I think, but for the
life of me I can't figure this out.

I have two variables of data type Date.

DateFrom
DateTo

I'm attempting to get it so I can work out how many days there are between
these two dates.

DateFrom = 01/04/08
DateTo = 04/04/08
The Result should be 4.

I was thinking just grab the Day from the date and that'd be easy, but the
problem arises when you have dates that span a few months in distance.

Thank you for any help thrown in this general direction :) .