Today's date minus two

I have a spreadsheet where I am trying to program two things:

The first is I want an expression that displays two days before today's date, here is what I have

Please Login or Register  to view this content.

I get an error 'Operator '-' is not defined for types 'Date' and 'Integer'.

The second thing is I want each column to fill with one of three colors(red, yellow, green) depending on what color is typed in each cell and if it doesn't have one of those colors it should be transparent, here is the code:

Please Login or Register  to view this content.

and the error
[BC30201] Expression expected.

Any ideas on what I am missing for each one.

Thanks guys or gals, I was able to figure out both problems.

Thanks