Formula help.

System

This discussion was created from comments split from: Count if Date Column has any dates older than 7 days.

Angela Cathey

How would I change this formula if I want to apply conditional formatting to a "Date Needed" column. I want to highlight the date needed column if it is less than 7 days from the day it was requested in the "Request Date" column. I tried this and it didn't work. =IF([Date Needed]@row < ([Request Date]@row, (-7), "Yes")

Jason Tarpinian

Try:

=IF(NETDAYS([Date Needed]@row, [Date Requested]@row) < 7, "Yes")

And play around with what works best, with NETWORKDAYS vs NETDAYS. Or to use your original syntax, it could be something like:

=IF([Request Date]@row > [Date Needed]@row - 7, "Yes")