Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sorted, non contiguous dates are in column "A" formatted as MM/DD/
YY. Target date is retrieved from an Inputbox. Format MM/DD/YYYY However. Because the stored value is not the same as the displayed Formatted date, I have tried. to use DateValue inside a Vlookup or Find What, and test for Less or Equal inside a Loop, since my range of dates may not be contiguous. So far I have not found the solution. Your help will be appreciated. J.P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Find Running Total Value or % at a given Target Date or vice versa | Excel Programming | |||
sumif date is greater than or equal chosen date | Excel Discussion (Misc queries) | |||
Find a date in a list | Excel Discussion (Misc queries) | |||
Date Validation - Must equal Sundays date | Excel Discussion (Misc queries) |