Use DAY w/ EOMONTH

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

• Format the cell's number format as percentage %

EOMONTH function

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

Syntax
EOMONTH(start_date, months)

Use DAY w/ EOMONTH

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

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

• Format the cell's number format as percentage %

EOMONTH function

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)

Use DAY & EOMONTH

The EOMONTH function returns a date representing the last day of a month which falls a specified number of months before or after another date.

Syntax
EOMONTH(start_date, months)

Formula

• start_date: TODAY()
• months: 0

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

Use DAY w/ EOMONTH

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

• Format the cell's number format as percentage %

EOMONTH function

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

Syntax
EOMONTH(start_date, months)

Use EOMONTH

=(EOMONTH(TODAY(),0)-today())/DAY(EOMONTH(TODAY(),0))

Use DAY & EOMONTH

The EOMONTH function returns a date representing the last day of a month which falls a specified number of months before or after another date.

Syntax
EOMONTH(start_date, months)

Formula

• start_date: TODAY()
• months: 0

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