| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count date
Hi, I would like to use the conditional formatting. I can use it for numeric,
but how to count date for 2 column ? If I want column B can not be 7 days more than column A. If not, Column B will show a different colour. How can it be done ? Hardware deliver date Deployment Date 1 1/11/2007 2/11/2007 2 1/11/2007 1/19/2007 3 12/11/2007 12/15/2007 4 12/12/2007 12/15/2007 5 12/13/2007 12/20/2007 6 12/14/2007 12/20/2007 7 12/15/2007 12/20/2007 Suppose 2 b & 5 b will show a different colour. Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count a record if it contains a date within a date range | Excel Worksheet Functions | |||
| count the mean in few date but on de date it has various data | Excel Worksheet Functions | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
![Jason Au Yeung[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
