| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell1 must be blank before cell2 can except date
Hello to all.
In column F, I have a date for a prelimenary contract and in column G is the date contract is acepted. I have cells doing calcs on G, only if it contains a date. What I need is something to say, "You can't enter a date here until you delete the date in F", when someone tries to enter a date in G. Some kind of validation formula? Thanks. Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Threaded Mode
