Stop date formula from changing

C

CevaClerkII

I'm looking for a way to make the date formula, =today() to only roll to
the next day, then stop.
 
F

FSt1

hi
as long as it's a fomula, not going to happen.
copy the formula and paste it as values.

regards
FSt1
 
R

Richard

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
 
Top