Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days of a given month
Hi!
Can anybody help me? I need to get the number of days on a given month-year. (ie Jan-07 = 31 days, etc) Is there an easy way to get it? Thnx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days of a given month
Put a date in a1 and this will return the days in the month od that date
=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1) Mike "Jepane" wrote: Hi! Can anybody help me? I need to get the number of days on a given month-year. (ie Jan-07 = 31 days, etc) Is there an easy way to get it? Thnx |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days of a given month
If the date is in cell D6, the following formula in E6 formatted as "dd"
will give you the number of days. =DATE(YEAR(D6),MONTH(D6)+1,0) It would need to be a "proper date", for example, 16/02/2007. This would display as 28 Regards Trevor "Jepane" wrote in message ... Hi! Can anybody help me? I need to get the number of days on a given month-year. (ie Jan-07 = 31 days, etc) Is there an easy way to get it? Thnx |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days of a given month
Can anybody help me?
I need to get the number of days on a given month-year. (ie Jan-07 = 31 days, etc) Is there an easy way to get it? =DAY(DATE(YearNumber,MonthNumber+1,0)) Put the year number in the first argument, the month number PLUS one in the second argument and zero in the third argument. Rick |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days of a given month
Thanx
"Mike H" wrote: Put a date in a1 and this will return the days in the month od that date =DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1) Mike "Jepane" wrote: Hi! Can anybody help me? I need to get the number of days on a given month-year. (ie Jan-07 = 31 days, etc) Is there an easy way to get it? Thnx |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days of a given month
One suggestion
=WORKDAY(A1,15) in B1 Mike "Jepane" wrote: Hi! Can anybody help me? I need to get the number of days on a given month-year. (ie Jan-07 = 31 days, etc) Is there an easy way to get it? Thnx |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days of a given month
One suggestion
=WORKDAY(A1,15) To the newsgroup administrators: Please move this response down one thread. Thank you, Rick <g |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days of a given month
Required Analysis ToolPak add-ins
=DAY(EOMONTH(A1,0)) "Jepane" wrote: Hi! Can anybody help me? I need to get the number of days on a given month-year. (ie Jan-07 = 31 days, etc) Is there an easy way to get it? Thnx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
How to Set a fix # of days per month | Excel Worksheet Functions |