If you have a cell in time format than the end of the month is
=eomonth(mytime,0)

also
=eomonth(today(),0)

Here is a trick so you can enter the month number from 1 to 12 and get it to
work for every year including leap years.

==DAY(EOMONTH(DATE(YEAR(NOW())-1,12,1),A1)) where A1 is a month number 1 -
12. The second parameter of is an offset of the month with 0 being the
present month. You have to use a December date to get January to be an
offset of 1. To make usre it handle the leap year properly You have to put
in the present year.




"FOUAD" wrote:

I want to know about a function such as
=Sum( value / January * value)

I mean I need a value divided by total days of the month such as january,
february etc. & then multiplied again by a value. I want a function in which
I can put total days of the month say november automatically. I will be
greatful to hear from anybody.