Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count colored cells? | Excel Worksheet Functions | |||
VBA Code | Excel Discussion (Misc queries) | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |