Formula to display Count of Days in given month, using list of Startand End Dates


D

Dave K

I have a large number of rows that contain a start date and end date.
I am attempting to generate a count of days within that date range
that are in a particular month, for example, Jan of 2011.

Any suggestions for a formula that could be used to display the
amounts shown in Column C would be helpful.

Layout is:

A B C
Start Date End Date Count of Days in Jan2011
1/10/11 4/7/11 21
2/6/11 3/1/11 0
12/20/10 2/15/11 31
Etc.
 
Ad

Advertisements

D

DCG-jaeson

Dave,

I think the best way is to create a table from Start Date to End Date
then use the Formula below each cell in the table =text(cell,"m") then
count all 1

Cheerz!
~jaeson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top