The formula should work, but perhaps without any spaces between the "d"s, for example:
Code:
=TEXT(TODAY(),"dddd")
The second problem will depend on how your spreadsheet is arranged. It would be helpful if you'd post a sample of your timetable spreadsheet; with sensitive info changed/removed of course.
Cheers,