Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date comparison help
Hi,
I'm trying to use the less than operator to compare dates in a worksheet against the date in a variable. The = sign works ok, but neither the = or <= does not. Here is the code, any help in using mainly the = operator would help greatly. Do While Not IsEmpty(ActiveCell) If ActiveCell.Value = startDates Then startRange = ActiveCell.Address Exit Sub Else ActiveCell.Offset(1, 0).Select End If Loop Thanks CathyZ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date comparison help
A tough one. Is startDates declared as a number, or date variable?
Are the dates in the column Excel-readable dates (a number representing the elapsed days since 1/1/1900, then formatted as a date)? If the cells are text instead of numbers and startDates is a string variable, that would explain why the = sign works but not the = or <=. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date comparison help
"Dave O" wrote: A tough one. Is startDates declared as a number, or date variable? Are the dates in the column Excel-readable dates (a number representing the elapsed days since 1/1/1900, then formatted as a date)? If the cells are text instead of numbers and startDates is a string variable, that would explain why the = sign works but not the = or <=. Hi Dave, startDates declared as a date Dim startDates As Date and the column is formatted as a date, if I enter 1/1/01 it formats it to 01/01/2001, CathyZ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
date comparison help
"Dave O" wrote: A tough one. Is startDates declared as a number, or date variable? Are the dates in the column Excel-readable dates (a number representing the elapsed days since 1/1/1900, then formatted as a date)? If the cells are text instead of numbers and startDates is a string variable, that would explain why the = sign works but not the = or <=. I've sorted it out, what you wrote had me thinking, so I made one change in my code and I think it works. When I made the worksheet active, I put the cursor at the top of the column, but the first row had column headings, so I now made the second row active, instead of the first and it worked. I thought the program would just see the heading as a string and then go down to the next row. But thanks much for jogging my thinking cap. CathyZ |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
date comparison help
Happy to help, if only indirectly!
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
date comparison help
Happy to help, if only indirectly!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Date comparison | Excel Discussion (Misc queries) | |||
Date Math Problem | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |