Need help in Colored cell

[Santosh080]

Hello Friends,

I have a excel sheet like this where some dates are colored. I want number days (30, 31 etc.) agaist that colored date 's month like below. i have huge amout data so i can not do mannualy. Is there any formula for this?

Thanks

Dates	Debit	Credit	Interest		No of Days
01-04-2011
23-04-2011	1000	0	0
30-04-2011	0	0	747.12		30
12-05-2011	10000	0	0
14-05-2011	200000	0	0
26-05-2011	10000	0	0
31-05-2011	0	0	2459.38		31
02-06-2011	25000	0	0
10-06-2011	21000	0	0
13-06-2011	50000	0	0
18-06-2011	102000	0	0
23-06-2011	2000	0	0
30-06-2011	0	0	3877.69		30
07-07-2011	60000	0	0
13-07-2011	25000	0	0
31-07-2011	0	0	0
03-08-2011	2482	0	0
03-08-2011	6000	0	0
10-08-2011	30000	0	0
12-08-2011	15000	0	0
20-08-2011	15000	0	0
25-08-2011	25000	0	0
31-08-2011	0	0	0

 

[SanjayGMusafir]

Assuming dates are in Column A. Try this and revert.

=EOMONTH(A2,0)-Eomonth(A2,-1)

 

[SanjayGMusafir]

And if you want them only at the end of the month dates then

=Ifs(A2=EOMONTH(A2,0),EOMONTH(A2,0)-Eomonth(A2,-1),True,"")