Calc: Divide Monthly Pay by Number of Days in the Current Month

[mdpalow]

Hello!

I just can’t seem to find anything on Google that will help me figure this out.

I would like to divide my monthly pay by the number of days REMAINING in the current month. Basically, I would like to set a daily budget for how much I can spend.

EXAMPLE:

This is January (31 days in this month) and today is the 13th, so:

31-13 = 18 days remaining
$1000 / 18 = $55.55 remaining per day until the end of the month.

I would like the formula to use the current month because:

February has 28 days
April has 30 days

Obviously, the number of days being divided by $1,000 will change every day of the month and the $1,000 will reduce as money is spent throughout the month.

I’m not looking to add text to the cell. I would just like an integer to be the result (i.e. $55).

Oh, and just for clarity’s sake:

• The CURRENT day should be counted since I can/could spend money on the current day
• I’d like to round up to the next dollar value.

I hope I’ve been clear in what I’m trying to achieve.

Thank you in advance for any help you smart people can provide.

Michael

[mikekaganski]

Use TODAY, EOMONTH, ROUNDUP.

=ROUNDUP(1000/(EOMONTH(TODAY();0)-TODAY()+1))

@mdpalow

31-13 = 18 days remaining
$1000 / 18 = $55.55 remaining per day until the end of the month.

@mdpalow

The CURRENT day should be counted since I can/could spend money on the current day

Note that the last quote contradicts the previous one, where “18” does not count today.

@mdpalow

I would just like an integer to be the result (i.e. $55).

@mdpalow

I’d like to round up to the next dollar value.

Same inconsistency: 55 is not the “next dollar value” for “$55.55”.

[mdpalow]

@mikekaganski

=ROUNDUP(1000/(EOMONTH(TODAY();0)-TODAY()+1))

This is exactly what I wanted. Thank you very much!
You’re right about the contradiction. I typo’d that “18.”
Have a great day!