| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Event
I have the following formula on my worksheet that I was going to use to
record a date when a stock level is reached: IF($I3=$H3,TODAY(),"INCOMPLETE") Of course its not gunna work because after all 'tomorrows another day' so my formula is going to return a different date. What I need is the exact day that I3 =H3 to be noted so I guess I need an event right? I also need it to work on a range of cells. Not sure how to go about this. GK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bringing to a cell the last date an event occurred | Excel Discussion (Misc queries) | |||
| Create Outlook Calendar event from date in Excel | Excel Discussion (Misc queries) | |||
| I had template that when you changed date of the event, it automa. | Excel Worksheet Functions | |||
| Highlighting date cells before the event elapses | Excel Discussion (Misc queries) | |||
| Date/Time Picker Event Won't Fire | Excel Programming | |||
Threaded Mode
