a cell to display number of days in a month given in another cell

S

sudip

Hi everybody,

I know I may be asking a basic question, but the problem is driving me nuts.
I have month typed in one cell and I want to call the number of days in
another specific cell. How do I do that??

Regards

Sudip Roy
 
F

Franz Verga

sudip said:
Hi everybody,

I know I may be asking a basic question, but the problem is driving
me nuts. I have month typed in one cell and I want to call the number
of days in another specific cell. How do I do that??

Regards

Sudip Roy
Click to expand...


If, as you say, you have typed the month's name in a cell, say is F4, you
can have the number of days of the month in another cell in which you type
this formula:

=DAY(DATE(YEAR(VALUE("1/"&F4&"/"&YEAR(TODAY()))),MONTH(VALUE("1/"&F4&"/"&YEAR(TODAY())))+1,0))

You have to format as General or as Number the cell in which you insert the
formula.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top