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
[TABLE="width: 261"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Month Number[/TD]
[TD]Cumulative[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD="align: right"]1 [/TD]
[TD="align: right"]31 [/TD]
[/TR]
[TR]
[TD]Feb[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]59 [/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD="align: right"]3 [/TD]
[TD="align: right"]90 [/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD="align: right"]4 [/TD]
[TD="align: right"]120 [/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD="align: right"]5 [/TD]
[TD="align: right"]151 [/TD]
[/TR]
[TR]
[TD]Jun[/TD]
[TD="align: right"]6 [/TD]
[TD="align: right"]181 [/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD="align: right"]7 [/TD]
[TD="align: right"]212 [/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD="align: right"]8 [/TD]
[TD="align: right"]243 [/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD="align: right"]9 [/TD]
[TD="align: right"]273 [/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD="align: right"]10 [/TD]
[TD="align: right"]304 [/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD="align: right"]11 [/TD]
[TD="align: right"]334 [/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD="align: right"]12 [/TD]
[TD="align: right"]365 [/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

[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