Remember Me?

#1
October 13th 08, 06:48 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: May 2007 Posts: 110
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
October 13th 08, 06:51 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: May 2007 Posts: 110
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
October 13th 08, 06:54 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 3,268
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
October 13th 08, 07:00 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
Find days in a Month

=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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post NeSchw6G Excel Worksheet Functions 11 August 23rd 08 05:46 PM GARY New Users to Excel 1 April 19th 08 06:05 PM Tumar Excel Worksheet Functions 6 September 18th 07 03:36 PM catrrmg Excel Worksheet Functions 2 August 1st 07 12:04 PM Bart Excel Worksheet Functions 3 January 31st 07 07:40 PM

All times are GMT +1. The time now is 01:45 AM.