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

=IF(((TODAY())<M3),(IF(($S12+30)<=$M$3,0,2)))
where M3 is the Date when the formula should start showing
and S12 is the data that needs to be shown

<tbody>
</tbody>

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