Salamullah
Board Regular
- Joined
- Mar 28, 2011
- Messages
- 221
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]
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]