Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find days in a Month
I want to know how many days are in a month.
In A1 I have a date ex. 3/3/08. In B1 i want to give me total days in that month. Is there a formula for that. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find days in a Month
"Jman" wrote: I want to know how many days are in a month. In A1 I have a date ex. 3/3/08. In B1 i want to give me total days in that month. Is there a formula for that. nevermind i got it.. =DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find days in a Month
One way
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) format as general -- Regards, Peo Sjoblom "Jman" wrote in message ... I want to know how many days are in a month. In A1 I have a date ex. 3/3/08. In B1 i want to give me total days in that month. Is there a formula for that. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find days in a Month
Take your pick:
=32-DAY(A1-DAY(A1)+32) =DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) This one requires the Analysis ToolPak add-in be installed on Excel versions prior to Excel 2007. =DAY(EOMONTH(A9,0)) -- Biff Microsoft Excel MVP "Jman" wrote in message ... I want to know how many days are in a month. In A1 I have a date ex. 3/3/08. In B1 i want to give me total days in that month. Is there a formula for that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the First of the Month after 60 days | Excel Worksheet Functions | |||
excel to make the days cary over month to month automaticly | New Users to Excel | |||
Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
Find the number of days in a month | Excel Worksheet Functions | |||
Days per month for calculating storage days | Excel Worksheet Functions |