| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed date with IF-function (or any other ideas?)
Thank you very much, it worked:)
Best regards, Elina "Niek Otten" kirjoitti: Look he http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "p11p00" wrote in message ... Is it possible to add a fixed date automatically with if-function. I want to add a date to a neighboring cell when it is not empty meaning date is added automatically to A1, when someone is writing to neighboring cell A2. With IF(D3="";"";(TODAY())) -function returns always the current date, not the date of writing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixed time and date | Excel Discussion (Misc queries) | |||
| Genarate a fixed date with an IF function? | Excel Discussion (Misc queries) | |||
| Adding a fixed date to a cell | Excel Worksheet Functions | |||
| Run a macro on a fixed date cycle | Excel Discussion (Misc queries) | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hybrid Mode
