formula for date in cell

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.
 
O

OssieMac

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.
 
S

smartin

Wiktor said:
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.
Click to expand...

If the cell to check is B2, a formula like

=B2-TODAY()

will tell you the number of days between today and the date to check.

A positive number means the date is in the future. A positive number
less than 30 means it's approximately within a month.

You could use such formulae in conditional formatting to highlight dates
automatically.
 
Top