Conditional Date formula

[Pluribus]

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!

 

[T. Valko]

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 Format>Conditional 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

 

[smartin]

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.

 

[Pluribus]

Thanks very much - You have both helped a lot!

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.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks very much - You have both helped a lot!