LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default 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
 
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
Number of days in month counted from shortened name of month & yea Tumar Excel Worksheet Functions 6 September 18th 07 03:36 PM
Finding the number of Days in the month? Will Excel Discussion (Misc queries) 1 April 13th 07 09:37 PM
Fuction that gives number of days of a given month FGOMEZ Excel Worksheet Functions 3 April 21st 06 07:44 PM
Number of Days in the Month Beth Excel Discussion (Misc queries) 2 March 2nd 06 03:44 PM
number of days in a month Ryan Proudfit Excel Worksheet Functions 8 April 7th 05 08:02 PM


All times are GMT +1. The time now is 03:49 PM.

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

About Us

"It's about Microsoft Excel"