+5I 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?
Best answer by JohnRomano
Yes it did - Thank you!
+7You can achieve this using several built-in formulas.
Formula numeric, then set the percentage property, then the formula: Day( Today() ) / Day( LastDayOfMonth( Today() ) )
+7@JohnRomano did this solution work for you?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
