| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of days in month counted from shortened name of month & yea
I'd need to get the number of days in a month from the shortened name of
month and a year. I have for example JAN in cell A1, and 2007 in cell A2, and I would need to get the 31 as a result. Any suggestions? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of days in month counted from shortened name of month & yea
One way:
=DAY(DATE(YEAR("1-"&A1&"-"&B1),MONTH("1-"&A1&"-"&B1)+1,0)) -- David Biddulph "Tumar" wrote in message ... I'd need to get the number of days in a month from the shortened name of month and a year. I have for example JAN in cell A1, and 2007 in cell A2, and I would need to get the 31 as a result. Any suggestions? Thanks in advance! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of days in month counted from shortened name of month &
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)) -- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of days in month counted from shortened name of month &
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)) -- |
|
#5
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)) -- |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of days in month counted from shortened name of month & yea
On Tue, 18 Sep 2007 00:12:00 -0700, Tumar
wrote: I'd need to get the number of days in a month from the shortened name of month and a year. I have for example JAN in cell A1, and 2007 in cell A2, and I would need to get the 31 as a result. Any suggestions? Thanks in advance! =DAY(--(A1&A2)+32-DAY(--(A1&A2)+32)) should do what you want. --ron |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of days in month counted from shortened name of month & yea
Try this formula:
=DAY(EOMONTH(A1&A2,0)) "Tumar" wrote: I'd need to get the number of days in a month from the shortened name of month and a year. I have for example JAN in cell A1, and 2007 in cell A2, and I would need to get the 31 as a result. Any suggestions? Thanks in advance! |
| 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 | |||
Linear Mode
