|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 08:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com