Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formula with date | Excel Discussion (Misc queries) | |||
Conditional Formula w/Date=Where did I go wrong? | Excel Worksheet Functions | |||
conditional date formula | Excel Worksheet Functions | |||
Conditional formula date | Excel Worksheet Functions | |||
Conditional formula date | Excel Worksheet Functions |