Number of days left in the current month

Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".

	A
1	=TODAY() = Sunday 01 May 2022
2	=NOW() = Sunday 01 May 2022 18:37:54

Related Formulas

Number of days left in the current year
Number of days that have passed in the current month
Number of days that have passed in the current year