Automated date excel function

[wimpie2001]

Hello,

I am currently working on a sheet but i ran into some troubles.

* First i would need automated date where every dat the next day adds in the next colomn, problem is i have tried with TODAY() but then yesterday changes olso unless i manually select the cell and use F2 + F9 to hold the value.

* Next i would need some kind of help with conditional formatting, so if in the problems cell is somethign filled in, then today's date cell must become red. now problem is i tried using this when problem cell is not empty, but then with my TODAY() all the cells become red cus date ist hold. Or perhaps i should work that peaple fill in an "x" manually on the date when there is a problem. and then is cell isnt empty to red, but then only if there is a previous cell red, it needs to change to range, any ideas?

* Hope you understand my problem a bit, now i think i might need to use VBA cus it's not easy with excel formulas only i suppose. And i know how to work with VBA but not how to use it in excel

* My example file in attach.

Wim