VBA to work out if a date is overdue

[ryandonovan22]

Hello,

I need a Macro to work out if a range of dates are overdue based on comparing expected delivery date against todays date

There could be any number of rows each week so it will have to perform the calculation over an undetermined range.

If I was to produce an if statement within the cell this is what I would use =if(G2<TODAY(),"Overdue",OK") and drag the formula down
<today(),"overdue","ok") range.

for the purpose of the VBA formula, this data will need to be placed into column N

Thanks,
Ryan.</today(),"overdue","ok")>

 

[alansidman]

Are your dates in column G formatted as dates or are they text that look like dates. My code ran fine in my test worksheet, so I know the logic is correct if the dates in column G are in fact dates which they were in my test sheet. Without actually seeing your workbook, this will be difficult to analyze.