using time formulas to activate a formula and then stop it

[Caniffis]

Hi, can anyone help me?

I m trying to create a formula that will pull data from a data set but only show the data at the start of a month and then at the end of that month lock the data in place so that another cell will show the data for the next month.

the formula I have is as follows
[TABLE="width: 500"]
<tbody>[TR]
[TD]=IF(((TODAY())<M3),(IF(($S12+30)<=$M$3,0,2)))[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]where M3 is the Date when the formula should start showing[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]and S12 is the data that needs to be shown[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

If there is any way to do this I would be grateful to know how. I know this is probably easy in VBA but I can not use that so need a formula for this.

 

[Caniffis]

sorry the formula didn't come through here it is

=IF(((TODAY())<M3),(IF(($S12+30)<=$M$3,0,2)))

 

[Caniffis]

=if(((today())<m3), (if(($s12+30)<=$m$3,0,2)))

 

[Caniffis]

= if (((today()) < M3),
(IF (( $S12+30)<=$
M$3,0,2 )))

sorry the formula doesn't want to be posted