|You can not use a formula to hide rows or data. You would need some VBA, i.e. a macro.|
Have you considered a separate worksheet for each month and a summary sheet linked to the others to consolidate the data?
You could hide every sheet except for the current month and then use the steps given here to prevent the users from unhiding the other months:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.