| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop date formula from changing
I'm looking for a way to make the date formula, =today() to only roll to
the next day, then stop. -- Medzzz |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop date formula from changing
hi
as long as it's a fomula, not going to happen. copy the formula and paste it as values. regards FSt1 "CevaClerkII" wrote: I'm looking for a way to make the date formula, =today() to only roll to the next day, then stop. -- Medzzz |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop date formula from changing
Try this: =IF(B3="","",IF(C3="",NOW()+1,C3)) Go to
TOOLS/OPTIONS/CALCULATIONS, Check ITERATION. When you put something in B3 todays date will be put in C3 and add 1 day and will not change the next day as long as something is in B3. Adjust cell to your needs. Hope this helps "CevaClerkII" wrote: I'm looking for a way to make the date formula, =today() to only roll to the next day, then stop. -- Medzzz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Stop Date Values from Changing to Formulas | Excel Worksheet Functions | |||
| How to stop text changing to date | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing numbers into a date? | Excel Discussion (Misc queries) | |||
| stop changing data to date | New Users to Excel | |||
Linear Mode
