Karine,

Let's say that you have a date in cell A3 - today's date Nov 29, 2007. 90 days from now is =A3+90
or Feb 27, 2008.

Where would the date Feb 27, 2008 be located on your sheet? Is it in a header row? Is it down a
column? Is it filled into cell B3? Do you have a formula somewhere that would return that date? Or,
and this is what I am beginning to think, are you really just interested in using a formula to
return that date?

If you really just want the date, then use

=A3+90

Or, if A3 might not be filled in, you could use this to keep the cell looking blank until A3 is
filled in:

=IF(A3="","",A3+90)

BUT If you really want 3 months instead of 90 days, then use

=DATE(YEAR(A3),MONTH(A3)+3,DAY(A3))

For 6 months:
=DATE(YEAR(A3),MONTH(A3)+6,DAY(A3))

For one year:
=DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))

HTH,
Bernie
MS Excel MVP


"Karine" wrote in message
...
If i had cell A3 highlighted and I wanted to highlight 90 days from that cell
whats my formula? I have tried NOW=()+90, & =AND (A3<,""A3<TODAY()+90) in
conditional formatting

I just want to highlight the cells, somehow I wanted the formula to know I
want it to skip 90 days/cells ahead and highlight the same color in that cell.
Hopefully this is clear enough. I'm sorry I'm trying to be clear but it's a
hard chart to explain.

Karine

"Bernie Deitrick" wrote:

Karine,

Sorry, that isn't clear. Do you store a date anywhere? How do you indicate that maintenance
occurred? What are your headers? Do you have one column for every day?

HTH,
Bernie
MS Excel MVP


"Karine" wrote in message
...
The months that the checks are required I will collect from other sources.
WEEK 1 week
2 M T W T F S S
Equipment Name 31 1 2 3 4 5 6 etc...
ROBOT 1

Thats what the workbook likes like but it goes for 52 weeks with the same
set up. If The maint check for Robot 1 was on (Monday 31 and is checked every
three months) i would want to highlight i would want to skip 90 (cells/days)
over and highlight that day.
Hopefully that clears things up a little bit.
Thanks again.
Karine