Hi I have a list of dates that will be entered, i have already a formula
that will calculate say 2 years on from the date, but i need the conditional
formatting to change the font to show me the dates from a month in advance,
In the dialog box i have tried

1. =today
2. between =today and =today+31

but im getting intermittent results, can anyone help?

Ta