| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unvaried date as part of a formula
Basic idea: =IF(ISNUMBER(V10), DATE). This doesn't work, so how do I get
Excel to give me the current date in to this formula, but without updating when I open the document in future? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unvaried date as part of a formula
See this:
http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "EMW103" wrote in message ... Basic idea: =IF(ISNUMBER(V10), DATE). This doesn't work, so how do I get Excel to give me the current date in to this formula, but without updating when I open the document in future? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date converts to number when part of a formula | Excel Discussion (Misc queries) | |||
| DATE as part of a formula | Excel Discussion (Misc queries) | |||
| Matching month part of date only | Excel Discussion (Misc queries) | |||
| Extracting Part of a Date | Excel Discussion (Misc queries) | |||
| Look up part of a date | Excel Worksheet Functions | |||
Linear Mode
