How do I account for leap years when substract 90 days from the target date?

Hello Smartsheet Experts,

How do I account for leap years when substract 90 days from the target date?

For example, if my target date is 4/30/2024.

Thank you

Answers

  • Stefan
    Stefan ✭✭✭✭✭✭

    Hi @Emi,

    to my knowledge, Smartsheet's internal calendar incorporates that info. So 4/30/2024 - 90 = 1/31/2024 and 4/30/2023 - 90 = 1/30/2023.

    Hope this helps!

    Stefan

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!