Comparing dates in excel

[Pandab2002]

I want to be able to quickly browse a spreadsheet to see how many items are "past due". I am trying to build a process that looks at dates in a column and compares it to todays date. If it is before today's date I want to count it, if it after today's date i want to ignore it.

z = Format(Now, "m/d/yyyy")
If date < z Then a = a + 1 (or something like that)

any suggestions???

Thank you

 

[TonyJollans]

Hi Pandab2002,

The result of a Format is a STRING.

If you have DATES in your cells then simply compare them to (unformatted) Now.

If you have TEXT in your cells then you need to make sure you have properly comparable formats.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[dhulbert]

Pandab2002

Why not just do it with conditional formating.
Select the range you want and set the condition to be where cell value is greater then or equal to =now()