Hi, Astounding Thank you for your reply. Yes, I think it's a eight-digit number. I don't have definite definition for the week number of a month. It would be fine if the program can help to show the sequence of a week within a month. BTW, I got the following message by implementing your suggested code: NOTE: Invalid argument to function DAY(20021030) at line 1998 column 33. If you have any suggestion, please let me know. Thank you very much.
... View more