Conditional Date formula

P

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

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
 
S

smartin

Pluribus said:
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.
 
P

Pluribus

Thanks very much - You have both helped a lot!

smartin said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top