| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date with CF
I' like to find a formula to do conditinal formating for cells with no colors
containing dates to turn green when is 6 month before a due date ( with a reference date), and red when is 3 month before. Also in different sheet I need a formula that gives me the date of 9 months ahead of a reference date in another cell. Thank you very much. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date with CF
If Due date is in cell A1, enter this formula in the box where Excel allows
you to enter your own formula. =A1EDATE(A1,-6) Format = Green =A1EDATE(A1,-3) Format = Red "FC" wrote: I' like to find a formula to do conditinal formating for cells with no colors containing dates to turn green when is 6 month before a due date ( with a reference date), and red when is 3 month before. Also in different sheet I need a formula that gives me the date of 9 months ahead of a reference date in another cell. Thank you very much. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date with CF
Same with the second question:
If reference date is in cell A1 =EDATE(A1,9) Format as date "FC" wrote: I' like to find a formula to do conditinal formating for cells with no colors containing dates to turn green when is 6 month before a due date ( with a reference date), and red when is 3 month before. Also in different sheet I need a formula that gives me the date of 9 months ahead of a reference date in another cell. Thank you very much. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CORRECTION!!!
Formulas is:
=TODAY()EDATE(A1,-6) Format Green =TODAY()EDATE(A1,-3) Format Green "Tevuna" wrote: If Due date is in cell A1, enter this formula in the box where Excel allows you to enter your own formula. =A1EDATE(A1,-6) Format = Green =A1EDATE(A1,-3) Format = Red "FC" wrote: I' like to find a formula to do conditinal formating for cells with no colors containing dates to turn green when is 6 month before a due date ( with a reference date), and red when is 3 month before. Also in different sheet I need a formula that gives me the date of 9 months ahead of a reference date in another cell. Thank you very much. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date with CF
Thank you Tevuna for your help, appreciatte it.
"Tevuna" wrote: Same with the second question: If reference date is in cell A1 =EDATE(A1,9) Format as date "FC" wrote: I' like to find a formula to do conditinal formating for cells with no colors containing dates to turn green when is 6 month before a due date ( with a reference date), and red when is 3 month before. Also in different sheet I need a formula that gives me the date of 9 months ahead of a reference date in another cell. Thank you very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
