Identify Blank Cell

[jkelly228]

Hello All,

I have some code below that identifies how delinquent an order is. This works great except that it identifies blank cells as being greater than a year. I need to add a line that says if the cell is blank then it should be titled "Not Booked".

I appreciate any help.

Please Login or Register  to view this content.

[Greg M]

Hi there,

Try the following code and see if it does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[jkelly228]

Greg,

Thank you very much. I areally appreciate it. That worked perfectly.

Kelly

[Greg M]

Hi Kelly,

Many thanks for your feedback - I'm glad I was able to help.

Greg M