| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of days in month counted from shortened name of month &
Thanks a bunch!
How stupid of me.. Now I'm getting it right. "David Biddulph" kirjoitti: Do you have your machine set up to expect a semi-colon (rather than a comma) as a list separator? -- David Biddulph "Tumar" wrote in message ... Thanks for the quick answer! I still get the " Formula you typed contains an error"-message I did try something similar yesterday, but every time I seem to get this error message referring to ,MONTH part of the formula. Any idea why this is & what would help? " One way: =DAY(DATE(YEAR("1-"&A1&"-"&B1),MONTH("1-"&A1&"-"&B1)+1,0)) -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Number of Days in the Month | Excel Discussion (Misc queries) | |||
| number of days in a month | Excel Worksheet Functions | |||
| Count number of days in given month? | Excel Worksheet Functions | |||
Hybrid Mode
