| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to get the number of days in the month ?
Hi,
I have a long list of dates. May I know if there is a formula for me to get the number of days in for that month in that year ? A B Total days Date in the month 5 06/05/2011 31 6 13/02/2011 28 7 24/08/2011 31 8 7/12/2011 31 200 09/04/2011 30 Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to get the number of days in the month ?
Try one of these...
=DAY(EOMONTH(A5,0)) That requires that the Analysis ToolPak add-in be installed in Excel versions 2003 and earlier. =32-DAY(A5-DAY(A5)+32) =DAY(DATE(YEAR(A5),MONTH(A5)+1,0)) -- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Hi, I have a long list of dates. May I know if there is a formula for me to get the number of days in for that month in that year ? A B Total days Date in the month 5 06/05/2011 31 6 13/02/2011 28 7 24/08/2011 31 8 7/12/2011 31 200 09/04/2011 30 Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to get the number of days in the month ?
Hi Valko,
i try =32-DAY(A5-DAY(A5)+32) and it works. Thanks for your help. Low -- A36B58K641 "T. Valko" wrote: Try one of these... =DAY(EOMONTH(A5,0)) That requires that the Analysis ToolPak add-in be installed in Excel versions 2003 and earlier. =32-DAY(A5-DAY(A5)+32) =DAY(DATE(YEAR(A5),MONTH(A5)+1,0)) -- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Hi, I have a long list of dates. May I know if there is a formula for me to get the number of days in for that month in that year ? A B Total days Date in the month 5 06/05/2011 31 6 13/02/2011 28 7 24/08/2011 31 8 7/12/2011 31 200 09/04/2011 30 Thanks Low -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to get the number of days in the month ?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Hi Valko, i try =32-DAY(A5-DAY(A5)+32) and it works. Thanks for your help. Low -- A36B58K641 "T. Valko" wrote: Try one of these... =DAY(EOMONTH(A5,0)) That requires that the Analysis ToolPak add-in be installed in Excel versions 2003 and earlier. =32-DAY(A5-DAY(A5)+32) =DAY(DATE(YEAR(A5),MONTH(A5)+1,0)) -- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Hi, I have a long list of dates. May I know if there is a formula for me to get the number of days in for that month in that year ? A B Total days Date in the month 5 06/05/2011 31 6 13/02/2011 28 7 24/08/2011 31 8 7/12/2011 31 200 09/04/2011 30 Thanks Low -- A36B58K641 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to get the number of days in the month ?
Try this where your date ios in cell A1
=DAY(DATE(YEAR(A1), MONTH(A1), 0)) -- HTH... Jim Thomlinson "Mr. Low" wrote: Hi, I have a long list of dates. May I know if there is a formula for me to get the number of days in for that month in that year ? A B Total days Date in the month 5 06/05/2011 31 6 13/02/2011 28 7 24/08/2011 31 8 7/12/2011 31 200 09/04/2011 30 Thanks Low -- A36B58K641 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to get the number of days in the month ?
You mean
=DAY(DATE(YEAR(A3), MONTH(A3)+1, 0)) If this post helps click Yes --------------- Jacob Skaria "Jim Thomlinson" wrote: Try this where your date ios in cell A1 =DAY(DATE(YEAR(A1), MONTH(A1), 0)) -- HTH... Jim Thomlinson "Mr. Low" wrote: Hi, I have a long list of dates. May I know if there is a formula for me to get the number of days in for that month in that year ? A B Total days Date in the month 5 06/05/2011 31 6 13/02/2011 28 7 24/08/2011 31 8 7/12/2011 31 200 09/04/2011 30 Thanks Low -- A36B58K641 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to get the number of days in the month ?
You are correct...
-- HTH... Jim Thomlinson "Jacob Skaria" wrote: You mean =DAY(DATE(YEAR(A3), MONTH(A3)+1, 0)) If this post helps click Yes --------------- Jacob Skaria "Jim Thomlinson" wrote: Try this where your date ios in cell A1 =DAY(DATE(YEAR(A1), MONTH(A1), 0)) -- HTH... Jim Thomlinson "Mr. Low" wrote: Hi, I have a long list of dates. May I know if there is a formula for me to get the number of days in for that month in that year ? A B Total days Date in the month 5 06/05/2011 31 6 13/02/2011 28 7 24/08/2011 31 8 7/12/2011 31 200 09/04/2011 30 Thanks Low -- A36B58K641 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to get the number of days in the month ?
What about
=DAY(EOMONTH(A5,0)) gwen "Jacob Skaria" wrote: You mean =DAY(DATE(YEAR(A3), MONTH(A3)+1, 0)) If this post helps click Yes --------------- Jacob Skaria "Jim Thomlinson" wrote: Try this where your date ios in cell A1 =DAY(DATE(YEAR(A1), MONTH(A1), 0)) -- HTH... Jim Thomlinson "Mr. Low" wrote: Hi, I have a long list of dates. May I know if there is a formula for me to get the number of days in for that month in that year ? A B Total days Date in the month 5 06/05/2011 31 6 13/02/2011 28 7 24/08/2011 31 8 7/12/2011 31 200 09/04/2011 30 Thanks Low -- A36B58K641 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to get the number of days in the month ?
One way
=DATE(YEAR(A3),MONTH(A3)+1,0)-DATE(YEAR(A3),MONTH(A3),0) and format the formula cell to General.. If this post helps click Yes --------------- Jacob Skaria "Mr. Low" wrote: Hi, I have a long list of dates. May I know if there is a formula for me to get the number of days in for that month in that year ? A B Total days Date in the month 5 06/05/2011 31 6 13/02/2011 28 7 24/08/2011 31 8 7/12/2011 31 200 09/04/2011 30 Thanks Low -- A36B58K641 |
| Reply |
| 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 | |||
| Finding the number of Days in the month? | Excel Discussion (Misc queries) | |||
| Fuction that gives number of days of a given month | Excel Worksheet Functions | |||
| Number of Days in the Month | Excel Discussion (Misc queries) | |||
| number of days in a month | Excel Worksheet Functions | |||
Hybrid Mode
