| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to input and compare date ranges
I need to allow the user to input a date range From-To through a form and
the date range should be placed in cells A1and A2 for in QQQ.xls. Then the macro should compare the date range entered with the dates in column B in another spreadsheet -ABS.xls and count only the records within that date range. The result should be in a cell K1 in QQQ.xls for example. Any help will be appreciated Thanks Vlad |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to input and compare date ranges
I have a date selection userform example on my website.
-- Rob van Gelder - http://www.vangelder.co.nz/excel "vlad" wrote in message ... I need to allow the user to input a date range "From"-"To" through a form and the date range should be placed in cells A1and A2 for in QQQ.xls. Then the macro should compare the date range entered with the dates in column B in another spreadsheet -ABS.xls and count only the records within that date range. The result should be in a cell K1 in QQQ.xls for example. Any help will be appreciated Thanks Vlad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I include a date input box in a macro? | Excel Discussion (Misc queries) | |||
| Macro about date compare | Excel Discussion (Misc queries) | |||
| compare date to various date ranges and sum value | Excel Worksheet Functions | |||
| compare date ranges to set up eq | Excel Worksheet Functions | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
Linear Mode
