How To Calculate Number Of Days In Month So Far

I am wondering if there is a formula to calculate the number of days in the month to date so I can use it in a formula to calculate a monthly trend. For example, by the 10th of December we have 24 closed deals and we need to calculate the monthly trend to see if we're on track to hitting our targets. With the above outputs, the equation would look like:

24 deals / 10 days * 31 total days in the month = 74.4 monthly trend

I hope that is clear enough. Thanks for any and all help!

Tags:

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    =DAY(TODAY())

    should work for how many days into the current month we are.


    =DAY(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1), DATE(YEAR(TODAY()) + 1, 1, 1)) - 1)

    and this will automatically determine how many days are in the current month to populate that "31" portion so that it will always be the total number of days in the month regardless of whether there are 28, 29, 30, or 31.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!