| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days in a month
On Sat, 5 Jan 2008 22:27:00 -0800, Sena wrote:
Hi there, Am looking a formulae that would return the number of days for a given month. eg : A1 = 1/1/07 ( meaning Jan ) A2 = need the number of days in Jan (result - 31) B1 = 1/11/07 ( meaning Nov ) B2 = need the number of days in Nov (result -30) Thanks If you have the Analysis Tool Pak installed, or are using Excel 2007, you can try: =DAY(EOMONTH(A1,0)) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
| Days per month for calculating storage days | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| Dates - Several Days In a month to month only | Excel Discussion (Misc queries) | |||
Threaded Mode
