Forum Discussion

JohnRomano's avatar
JohnRomano
Qrew Cadet
9 days ago
Solved

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...
formulas
  • JohnRomano's avatar
    JohnRomano
    3 days ago

    Yes it did - Thank you!

Mez's avatar
Mez
Qrew Assistant Captain
9 days ago

You can achieve this using several built-in formulas. 

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