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

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

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