New case of Month Formulas
Create a table with the month name in column A and the # days in column B.
Suppose this is on Sheet2. Then =vlookup("June",Sheet2!A:B,2,0) would return
the cell from column B in the same row where you have June in column A.
Alternately, if you have a particular date and want to know the number of
days in that month (February, after all, doesn't have the same number of days
each year), you can calculate that. Suppose the date is in A1. Then
=day(date(year(a1),month(a1)+1,0)) will show the number of days in that month.
--Bruce
"ahmed" wrote:
I need to put name of month in cell and I get for anther cell total days of
month
For example:
In Cell A1 July
In cell B1 the result showing 31 total days of July
In Cell A2 February
In cell B2 the result showing 28 total days of February
What formula for this case?
i search through discussion group but i did not found it
any help
Thanks
|