Return the percentage of the month that has elapsed up to today's date

Question

I want a formula to return the percentage of the month that has elapsed up to today's date.

For example, if today is April 6, and April has 30 days, then the result would be 20%:

6 / 30 = 20%

What formula should I use to perform this calculation?

Blindspots · Accepted Answer · 2024-04-07 13:14:16Z

0

Use DAY w/ EOMONTH

NA Locale
=DAY(TODAY())/DAY(EOMONTH(TODAY(),0))

International
=DAY(TODAY())/DAY(EOMONTH(TODAY();0))

Returns a date representing the last day of a month which falls a specified number of months before or after another date.

NA Syntax
EOMONTH(start_date, months)

International
EOMONTH(start_date; months)

edited Apr 7 at 13:14

answered Apr 6 at 22:09

Blindspots♦

7,4825 gold badges20 silver badges38 bronze badges

1

instead of "," gdocs accepted ";", but then it works! REALLY thanks!
– peterK88
Commented Apr 7 at 5:18
You must be in a locale that uses , as decimal separator. Therefore in Sheets you use ; as argument separator and \ as column separator in arrays. Without including a formula or decimal number in your question there's no clue to pick up on that. This site typically defaults to North-American syntax for better or worse. In future you can note your locale in your questions or simply assume you will need to make those changes. I'll normally show both syntaxes if I know OP doesn't use NA syntax
– Blindspots ♦
Commented Apr 7 at 13:04

Add a comment |