Conditional Formatting question
Bob, that didn't seem to work, though i tried applying it to the whole sheet
this is my layout:
Duration [a2] 2
[b2]
Helen [a3] 01/28/06
[b3]
Date Due [a4] =DATE(YEAR(B3)+B$2,MONTH(B3),DAY(B3)) [b4]
There are multiple names and dates.
maybe there is a shorter/easier formula to use too ?
Thanks
=DATE(YEAR(B3)+B$2,MONTH(B3),DAY(B3))
"Bob Phillips" wrote in message
...
Try a formula of
=AND(A2=TODAY()-31,A2<=TODAY())
where A2 is the cell in question
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Helen Holubowicz" wrote in message
...
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
|