Hi Mandusin,
You're making this harder than it needs to be.
Simply enter =TODAY() into the cell where you want the date to appear. Then choose Format|Format Cells|Date and select a date with the appropriate format. If you can't find one there, choose 'Custom' instead of 'Date' and use a custom format. For waht your first post describes, the format would be:
DDD d.m.yyyy
The second problem would require a lookup table with the classes for each day.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|