formula for date in cell

  • Thread starter Thread starter Wiktor
  • Start date Start date
W

Wiktor

I have got sells with future date for example 01-09-2009. I would like to get
this date marked before one mouth to this date. For example in day 01-08-2009
cell with date 01-10-2009 will be marked (by fat fontd or colour of cell
backgroud). I dont know is posiblle to write this formula.
 
Not sure that I understand your question. However, the following might point
you in the right direction.

If you have a column of dates then the following can be used to set the
color of the background of the cell containing a date that is one month after
today.

Select the cells containing the dates.
Select Conditional Format (See Help for how to do this)
In the Conditional Format dialog box, Select Formula.
Insert the following formula but replace A1 with the first cell in your
selection.
=A1=EDATE(TODAY(),1)
Select Format in the conditional formatting dialog box and set the
background (Under Fill or Patterns tab depending on version of xl) to your
desired color.

Click OK (or Apply depending you version of xl) until you exit the
Conditional formatting.
 
Back
Top