Excel conditional formatting dates within 14 days is possible using the following formula as the conditional formatting rule in the Conditional Formatting feature in the Home tab: AND(Date Value>(TODAY()-14)) The formula will highlight cells within the chosen cell range that have a date within 14 days of the current date.