Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Static date formula
i am building a form in excel and i need to place a date next to a cell when
that cell has information entered into it. the problem is that every time the sheet recalculates the date changes, i don't want this to happen but the workbook still needs to recalculate as there are other formulas present. is there a way to restrict the number of times a specific cell can recalculate? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Static date formula
Look he
http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Dude3966" wrote in message ... |i am building a form in excel and i need to place a date next to a cell when | that cell has information entered into it. the problem is that every time the | sheet recalculates the date changes, i don't want this to happen but the | workbook still needs to recalculate as there are other formulas present. is | there a way to restrict the number of times a specific cell can recalculate? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Static date formula
CTRL + ;(semi-colon) will produce a static date.
Or see Niek's post for event code from JE Gord Dibben MS Excel MVP On Wed, 20 Feb 2008 08:24:05 -0800, Dude3966 wrote: i am building a form in excel and i need to place a date next to a cell when that cell has information entered into it. the problem is that every time the sheet recalculates the date changes, i don't want this to happen but the workbook still needs to recalculate as there are other formulas present. is there a way to restrict the number of times a specific cell can recalculate? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Static date formula
Thaks very much the circular formula =IF(A1="","",IF(B1="",NOW(),B1)) was
spot on exactly what i was looking for. "Niek Otten" wrote: Look he http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Dude3966" wrote in message ... |i am building a form in excel and i need to place a date next to a cell when | that cell has information entered into it. the problem is that every time the | sheet recalculates the date changes, i don't want this to happen but the | workbook still needs to recalculate as there are other formulas present. is | there a way to restrict the number of times a specific cell can recalculate? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
static date | Excel Worksheet Functions | |||
Static Date Insertion Formula | Excel Discussion (Misc queries) | |||
Static Date | Excel Discussion (Misc queries) | |||
DATE STATIC | Excel Worksheet Functions | |||
Enter Static Date with a formula or macro | Excel Discussion (Misc queries) |