Forum Discussion

JohnRomano's avatar
JohnRomano
Qrew Cadet
3 days ago

Percentage through the month

I want to determine the percentage of the month completed; for example if today  is the 14th, and there are 30 days in April the percentage is 0.46. To keep the formula simple I can assume all months have 31 days--so Today()/31

I am struggling with the formual type, is it date is it number? 

  • Mez's avatar
    Mez
    Qrew Assistant Captain

    You can achieve this using several built-in formulas. 

    Formula numeric, then set the percentage property, then the formula: Day( Today() ) / Day( LastDayOfMonth( Today() ) )