Compare 2 date columns and add 10 days and highlight the rows

[jwp]

Am struggling with date adding. I have column A and column B in excel.

I want to use Date(Day(A,1)+10) or similar

I want to highlight and change the colour of a row if column B is greater than column A by 10 days.

Each worksheet contains different amounts of data how do I manage that also in the code?

Does that make sense?

Thanks

 

[VoG]

You can use Conditional Formatting with the CF formula

=B1-A1>=10

 

[jwp]

How do I eliminate weekends and only count work days?

Thanks

 

[VoG]

Try

=NETWORKDAYS(A1,B1)>=10

 

[jwp]

Cool will try and let you know.