Month's accumulated Numbers

[Salamullah]

I want formula to bring cumulative days number based on the month, need formula please.

Suppose month is Mar I want from Jan to Mar 90 and remaining months Zero
If month is Jun the figure from Jan to Jun should be 181 and remaining months Zero, so on so forth.

Jan 90
Feb 90
Mar 90
Apr 0
May 0
Jun 0
Jul 0
Aug 0
Sep 0
Oct 0
Nov 0
Dec 0

Month	Month Number	Cumulative
Jan	1	31
Feb	2	59
Mar	3	90
Apr	4	120
May	5	151
Jun	6	181
Jul	7	212
Aug	8	243
Sep	9	273
Oct	10	304
Nov	11	334
Dec	12	365

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[markmzz]

Here is a small modification in Tetra201's formula:

=(EDATE(1&A$1,1)-("1/"&$A$4))*(1*(2&A$1)>1*(1&A4))

Do some tests.

Markmzz