#1   Report Post  
Old October 13th 08, 06:48 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 110
Default 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   Report Post  
Old October 13th 08, 06:51 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 110
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find the First of the Month after 60 days NeSchw6G Excel Worksheet Functions 11 August 23rd 08 05:46 PM
excel to make the days cary over month to month automaticly GARY New Users to Excel 1 April 19th 08 06:05 PM
Number of days in month counted from shortened name of month & yea Tumar Excel Worksheet Functions 6 September 18th 07 03:36 PM
Find the number of days in a month catrrmg Excel Worksheet Functions 2 August 1st 07 12:04 PM
Days per month for calculating storage days Bart Excel Worksheet Functions 3 January 31st 07 07:40 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017