Conditional Date formula
 

Hi

I need to create a formula which takes the date in cell A1, adds 358 days,
and if the result is todays date or later return a value of Yes in a coloured
cell, otherwise return a value of No in a plain cell.

My Date format is DD/MM/YYYY.

Thanks for your help in advance!

Conditional Date formula
 

Try this...

=IF(A1+358=TODAY(),"Yes","No")

Use conditional formatting th color the cell.
Assume the cell is B1
Select cell B1
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the little box to the right:
=B1="Yes"
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Pluribus" wrote in message
...
Hi

I need to create a formula which takes the date in cell A1, adds 358 days,
and if the result is todays date or later return a value of Yes in a
coloured
cell, otherwise return a value of No in a plain cell.

My Date format is DD/MM/YYYY.

Thanks for your help in advance!

Conditional Date formula
 

Pluribus wrote:
Hi

I need to create a formula which takes the date in cell A1, adds 358 days,
and if the result is todays date or later return a value of Yes in a coloured
cell, otherwise return a value of No in a plain cell.

My Date format is DD/MM/YYYY.

Thanks for your help in advance!

Formula in your cell (say z1)
=if(a1+358=today(),"Yes",No")

Conditional Formatting in z1:
Cell Value Is
Equal To
Yes
Click Format and paint as needed.

Conditional Date formula
 

Thanks very much - You have both helped a lot!

"smartin" wrote:

Pluribus wrote:
Hi

I need to create a formula which takes the date in cell A1, adds 358 days,
and if the result is todays date or later return a value of Yes in a coloured
cell, otherwise return a value of No in a plain cell.

My Date format is DD/MM/YYYY.

Thanks for your help in advance!

Formula in your cell (say z1)
=if(a1+358=today(),"Yes",No")

Conditional Formatting in z1:
Cell Value Is
Equal To
Yes
Click Format and paint as needed.

Conditional Date formula
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Pluribus" wrote in message
...
Thanks very much - You have both helped a lot!

"smartin" wrote:

Pluribus wrote:
Hi

I need to create a formula which takes the date in cell A1, adds 358
days,
and if the result is todays date or later return a value of Yes in a
coloured
cell, otherwise return a value of No in a plain cell.

My Date format is DD/MM/YYYY.

Thanks for your help in advance!

Formula in your cell (say z1)
=if(a1+358=today(),"Yes",No")

Conditional Formatting in z1:
Cell Value Is
Equal To
Yes
Click Format and paint as needed.