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

Emi
Emi ✭✭
in Formulas and Functions

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

· Share on FacebookShare on Twitter

Answers

  • Stefan
    Stefan Community Champion

    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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!