raising a number by the number of days in a month formula

[sjc4]

hey, im trying to raise a number by the number of days in a month. i thought i could: 45*DAY(A1) but that does not seem to be working. any other tips?

 

[VoG]

Try

45*DAY(EOMONTH(A1,0))

Which requires the Analysis Toolpak from Tools > Add-Ins.

 

[Steve=True]

Days in a month:

=DAY(DATE(YEAR(A2),MONTH(A2)+1,))

http://www.mrexcel.com/forum/showthread.php?t=33567

 

[sjc4]

thanks a lot guys! i'll try these out. with your help im sure it'll work/or i'll figure it out now.

 

[sjc4]

hey guys, the above formulas are not cutting it. let me give you some background and maybe that will help the problem get solved. i have two columns of data that are thousands of lines long. in one column there is a date and in the column next to it there is a number. i need to multiply that number by days in a month of that exact date.

 

[VoG]

Try

=B1*DAY(EOMONTH(A1,0))

 

[barry houdini]

hey guys, the above formulas are not cutting it. let me give you some background and maybe that will help the problem get solved. i have two columns of data that are thousands of lines long. in one column there is a date and in the column next to it there is a number. i need to multiply that number by days in a month of that exact date.

So if A1 is today's date, 8th July and B1 contains 100 you want to multiply 31 (number of days in July) by 100 to get 3100?

VoG's formula should work for you....or here's another method avoiding EOMONTH

=(42-DAY(A1-DAY(A1)+42))*B1

 

[sjc4]

the formulas work. thanks guys. huge help. now, the root of problem is monthly rate of return... (1+A1)^1/B1*DAY(EOMONTH(A1,0))