If the cell holds a date, why not use a custom format of 'ddd' or 'dddd' to
get Mon or Monday
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"GregNga" wrote in message
...
Thanks to you both, I guess that was too obvious. One other question: Is
there a way to have a cell equal to the day of the week in format MON,
TUE,
WED, etc based on the date in another cell. I know WEEKDAY(A1) will give
it
in format 1,2,4 but I would like MON, TUE, WED format, thanks

"Bernard Liengme" wrote:

Regardless of Excel version: =A2+7 and format as date
If you meant 7 workdays: =WORKDAYS(A1,7)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"GregNga" wrote in message
...
In Excel 2000, how can I calculate cell A9 to be 7 days from the A2

I am now using Excel 2000 where I work and I have been used to doing
this
in
Excel 2003