You'd think that was an easy question, right?

Check Chip Pearson's website for the range of answers....

http://www.cpearson.com/excel/weeknum.htm

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Captain" wrote:



"Captain" wrote:

How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.

Thanks! Is there a way to get the week # for a specific date?