Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date help
Ive been trying to use an if statement to put a static date in a cell when a
certain condition is met. I do not want that date to change(update when the workbook is opened in the future) how can this be done?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date help
I would suggest some type of event code that adds a static timestamp rather
than have a formula-derived one which is difficult to keep static. But you can prevent a formula from updating using worksheet functions alone. Couple of methods on John McGimpsey's site One without VBA and one with. http://www.mcgimpsey.com/excel/timestamp.html Gord Dibben MS Excel MVP On Sun, 31 Jan 2010 14:18:01 -0800, camperguy7 wrote: Ive been trying to use an if statement to put a static date in a cell when a certain condition is met. I do not want that date to change(update when the workbook is opened in the future) how can this be done?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |