| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Start Date
The "Int" did the trick Rick!
The reason for that is VBA holds dates in a Double data type with the integer part holding the number of days past "date zero" (which, for VBA is December 30, 1899) and the fractional part holding the time value as the fraction of a 24 hour day. The Int function removes the fractional part which means it removes the time value. That allows you to compare it to a pure date value. Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wildcard for finding items that start with ? | Excel Discussion (Misc queries) | |||
| Calculating monthly start date with a start date | Excel Worksheet Functions | |||
| Determining an annual review date from an employee start date | Excel Worksheet Functions | |||
| Finding concurrent events from a list with a start and an end time | Excel Discussion (Misc queries) | |||
| VBA that automatically generates a series of cash flows based on a start date, an end date and frequency | Excel Programming | |||
Threaded Mode
