Conditionally hide rows in Excel

Hello. I am working on a workbook where I would like to conditionally hide rows. I know this needs to be done with VBA, however, I have never used VB period. I have rather fluent in C++, Java, PHP, Perl, etc, however, I have never messed with VB or VBA.

Basically I want to make a conditional statement like

=IF(OR(WEEKDAY(E1)=1, WEEKDAY(E1)=2), [show row], [hide row])

Does someone know of a VBA script that will accomplish this? I appreciate any help you can give me.