Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi Excel gurus, Does anybody know, how to add for example 70 days to date in cell and then use it in condition ? I have column with date in every cell. I need the date go to red color, when I add to date 70 days and the date go over specific date. Example - I have some date : 1.1.2005, now, if I add 70 days and the datum go over specific date, for example 1.2.2005, change color to red. I don't know, how to add days to date, and I don't know, how exactly build up a condition. Thanks in advance Satucha -- satucha ------------------------------------------------------------------------ satucha's Profile: http://www.excelforum.com/member.php...o&userid=26621 View this thread: http://www.excelforum.com/showthread...hreadid=488092 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
calculate the number of days from date received | Excel Worksheet Functions | |||
Merging Cells when one cell is a date | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) |