| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the =TODAY() option
I have used the =TODAY() option to get a date to enter into a field if
another cell meets the requirements I set. However, I do not want the date to change unless their is new data entered in the cell and it meets the requirements. Here is the formula I am currently using: =IF($K80,TODAY(),(IF($L80,TODAY()," "))) Basically, I want a date to be entered in a cell "J8" if K8, L8, or both are greater than 0. I do not want the date to change unless K8 or L8 have new data that are greater than 0. I am trying to date an activity. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
| Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option. | Excel Worksheet Functions | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Threaded Mode
