Stop date formula from changing

  • Thread starter Thread starter CevaClerkII
  • Start date Start date
C

CevaClerkII

I'm looking for a way to make the date formula, =today() to only roll to
the next day, then stop.
 
hi
as long as it's a fomula, not going to happen.
copy the formula and paste it as values.

regards
FSt1
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Dragging countif formula with changing criteria 3
Trailing 30 days sum calculation with excel 1
Excel Formula - Count Dates from another Sheet 8
Expanding Date formula 1
Formula not reading date format 3
Count Dates & Return as % 2
Help with formula 4
conditional format cells by date 2

Back
Top