| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't Update Function
I have a function that automatically puts the date into a cell if other cells
contain information. But I don't want the date to change everytime I open the spreadsheet. The function I have looks like this: =IF(b50,today(),"") How do I get it to only put in today's date, but not put in today's date everytime I open up the spreadsheet? -- RedFive |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Don't Update Function
Look he
http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "RedFive" wrote in message ... |I have a function that automatically puts the date into a cell if other cells | contain information. But I don't want the date to change everytime I open | the spreadsheet. The function I have looks like this: | =IF(b50,today(),"") | How do I get it to only put in today's date, but not put in today's date | everytime I open up the spreadsheet? | -- | RedFive |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function update | Excel Worksheet Functions | |||
| Auto Update Function | Excel Discussion (Misc queries) | |||
| Function Update | Excel Worksheet Functions | |||
| Is there a Timestamp function that does not update in Excel? | Excel Worksheet Functions | |||
| Timestamp function that does not update in Excel? | Excel Worksheet Functions | |||
Hybrid Mode
