| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the amount of days between two dates.
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 :) . |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :) . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding the amount of days between two dates.
What does the hash character mean?
And That worked great cheers :) "Mike H" wrote: 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 :) . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding the amount of days between two dates.
It's part of the syntax for formatting a user date in VB
"NateBuckley" wrote: What does the hash character mean? And That worked great cheers :) "Mike H" wrote: 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 :) . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum amount of days in another coloumn | Excel Worksheet Functions | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| set a warning in excel after a certain amount of days | Excel Discussion (Misc queries) | |||
| Calculating # of busn days, not just calendar days, between 2 dates? | Excel Programming | |||
Linear Mode
