View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default 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