Conditional format and comparing dates

H

Hank

How do I do this on a report?
If the difference between date1 and date2 is greater than 42 days then date
1 should be bold, else nothing. date1 is the control cell in which I'm
trying to enter the formula but I'm coming up with nothing.
 
M

Marshall Barton

Hank said:
How do I do this on a report?
If the difference between date1 and date2 is greater than 42 days then date
1 should be bold, else nothing. date1 is the control cell in which I'm
trying to enter the formula but I'm coming up with nothing.
Click to expand...


Try using the Expression Is" option with something like:

DateDiff("d", [date1], [date2]) > 42

Note that the [ ] are required.

You didn't say which date is the earlier date so you might
have to switch the 1 and 2.
 
Top