Days left in a month

**kalkwarfp** · 02-26-2012, 01:49 AM

Please can somebody help me. i am trying to figure out a way to create a daily budget calculator. i need to be able to tell excel that i have a balance of x rands. i need excel to calculate how many days of the month are left and work out how much can be spent per day. the calculator needs to update everyday as the days of the month get less and less.

please help

Philippe

**vlady** · 02-26-2012, 02:04 AM

hello
can you try this.

Please Login or Register  to view this content.

**Fotis1991** · 02-26-2012, 02:06 AM

Hi and welcome to the forum.

Try this formula.

=(DATE(YEAR(TODAY());MONTH(TODAY())+1;1)-1)-TODAY()

Change semi-colons to gomma, if you have to do it.

Hope to helps you.

**ConneXionLost** · 02-26-2012, 02:21 AM

Another option:

Please Login or Register  to view this content.

or if you have your date in another cell:

Please Login or Register  to view this content.

Cheers,

**iPete** · 02-29-2012, 08:56 AM

Ok, I have no idea how to use Excel properly. If I plug in, for example: =EOMONTH(TODAY(),0)-TODAY(), it just generates: 00/01/1900

If I plug in: =DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))-DAY(TODAY()), it generates: 0.

Where/how do I input the data needed to generate the required information?

I get paid on the last working day of the month and want to calculate a daily budget, which adjusts on a daily basis until pay day. i.e. If I spend less over a few days, the budget would increase proportionally.

Thanks

**ConneXionLost** · 03-01-2012, 04:35 AM

For this:

Originally Posted by iPete

Ok, I have no idea how to use Excel properly. If I plug in, for example: =EOMONTH(TODAY(),0)-TODAY(), it just generates: 00/01/1900

Change the cell format to "General".

**Nerdx** · 06-27-2012, 02:09 AM

Originally Posted by iPete

Ok, I have no idea how to use Excel properly. If I plug in, for example: =EOMONTH(TODAY(),0)-TODAY(), it just generates: 00/01/1900

If I plug in: =DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))-DAY(TODAY()), it generates: 0.

Where/how do I input the data needed to generate the required information?

I get paid on the last working day of the month and want to calculate a daily budget, which adjusts on a daily basis until pay day. i.e. If I spend less over a few days, the budget would increase proportionally.

Thanks

Put it all together and you don't have to change to the formatting:

=Day(EOMONTH(TODAY(),0)-TODAY())