| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TODAY formula
Open Close Name
03/06/08 03/07/08 mveach 04/01/08 04/07/08 mveach 04/05/08 05/12/08 mveach 04/14/08 04/18/08 mveach 04/14/08 04/15/08 mveach 04/26/08 04/28/08 mveach 04/27/08 01/00/00 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 04/28/08 mveach 04/29/08 05/12/08 mveach 05/09/08 05/13/08 mveach There are three records that are missing a close date... i want to create a formula that says: if a cell is empty then autofill with todays date and fill the cell red( if cell has a close date leave as is). Thanks -- sss |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TODAY formula
Jut put =TODAY() in the cell and then overwrite when you have a date.
-- __________________________________ HTH Bob "sed" wrote in message ... Open Close Name 03/06/08 03/07/08 mveach 04/01/08 04/07/08 mveach 04/05/08 05/12/08 mveach 04/14/08 04/18/08 mveach 04/14/08 04/15/08 mveach 04/26/08 04/28/08 mveach 04/27/08 01/00/00 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 04/28/08 mveach 04/29/08 05/12/08 mveach 05/09/08 05/13/08 mveach There are three records that are missing a close date... i want to create a formula that says: if a cell is empty then autofill with todays date and fill the cell red( if cell has a close date leave as is). Thanks -- sss |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TODAY formula
is there any conditioning I can do so that if they are empty they can
autoamitically turn into todays date and fill up with a red color so I can know they were the ones that were empty to begin with? Thank you -- sss "Bob Phillips" wrote: Jut put =TODAY() in the cell and then overwrite when you have a date. -- __________________________________ HTH Bob "sed" wrote in message ... Open Close Name 03/06/08 03/07/08 mveach 04/01/08 04/07/08 mveach 04/05/08 05/12/08 mveach 04/14/08 04/18/08 mveach 04/14/08 04/15/08 mveach 04/26/08 04/28/08 mveach 04/27/08 01/00/00 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 mveach 04/28/08 04/28/08 mveach 04/29/08 05/12/08 mveach 05/09/08 05/13/08 mveach There are three records that are missing a close date... i want to create a formula that says: if a cell is empty then autofill with todays date and fill the cell red( if cell has a close date leave as is). Thanks -- sss |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Having trouble with my formula ideas today | Excel Discussion (Misc queries) | |||
| Using today formula for a template | Excel Discussion (Misc queries) | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
| formula - Age today | Excel Worksheet Functions | |||
| Can I use TODAY Function in a formula that will not change it the. | Excel Discussion (Misc queries) | |||
Hybrid Mode
