I have a 2.5-hour loop, and I need help figuring out how to correctly set the dates. I tried something like this: =IF(TODAY() > B25, B25 + 5, B25), and it works, but the issue is that after the loop has finished a single iteration and passes B25 twice, it doesn't update again because that's not what the code says. So I need to manually change B25 every time, not to mention the other 4 days. My question is if there is some easy way to do it in one box or how do i make b25 change dates automatically?

An imagine of my Google Sheets.

  • Welcome to Web Applications. Consider registering your account to avoid accidentally losing access to your content by switching devices, browsers, or clearing your cookies. Registering is quick and you gain access to more site features. For more info see Why should I register my account?
    – Blindspots
    Apr 3 at 20:33
  • 1
    Please edit your question to show 1. what is in B25, 2. what you "want" it to do rather than simply explaining why it doesn't do it. I don't know what your actual expected behavior is. If we understand the point of it all we can help.
    – Blindspots
    Apr 3 at 20:40


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.