Need formula for # of days in each month when entry is made on a date range PLS HELP!

**abomb123** · 11-08-2006, 09:51 PM

Hello All I need help

Basically I need to have the formula to reflect the number of days each
month till the end of a date

and whenever I enter in a date range each month updates itself with the
number of days

For example

Start Date 9/6/06
End Date 2/6/07

Year 2006- Year 2007-
Jan: Jan:31
Feb: Feb: 6
Mar:
April:
May:
June:
July:
August:
September:25 (including start date day)
October: 31
November: 30
December: 31

Totaling 154 Days

Im Thinking A2 is start date B2 is End Date
Then D2 E2 F2 G2 etc shows each number of days..
Can Someone Help??

**mangesh_yadav** · 11-09-2006, 12:46 AM

Enter 1 to 12 from D1 to O1
Enter the following formula in D2 and copy up to O2
=SUMPRODUCT(--(MONTH($A$2-1+ROW(INDIRECT("1:"&($B$2-$A$2)+1)))=D1))

Assumptions:

Im Thinking A2 is start date B2 is End Date
Then D2 E2 F2 G2 etc shows each number of days..

**abomb123** · 11-09-2006, 05:22 PM

Thanks a lot

**oldchippy** · 11-09-2006, 06:18 PM

Originally Posted by abomb123

Hello All I need help

Basically I need to have the formula to reflect the number of days each
month till the end of a date

and whenever I enter in a date range each month updates itself with the
number of days

For example

Start Date 9/6/06
End Date 2/6/07

Year 2006- Year 2007-
Jan: Jan:31
Feb: Feb: 6
Mar:
April:
May:
June:
July:
August:
September:25 (including start date day)
October: 31
November: 30
December: 31

Totaling 154 Days

Im Thinking A2 is start date B2 is End Date
Then D2 E2 F2 G2 etc shows each number of days..
Can Someone Help??

Hi abomb123,

Attached is a solution to your question

oldchippy