dates.xls
This sample file will change the weekday in a cell automatically when the time changes from 'pm' to 'am' in other cells. See this month's Q&A to see how this works.

Online: N/A OS: Windows 95/98/Me/NT/2000/XP License: Free Requirements: Microsoft Excel Download dates.xls: Please insert disc 1