Conditional format and comparing dates

  • Thread starter Thread starter Hank
  • Start date Start date
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.
 
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.
 
Back
Top