|
Posted to microsoft.public.excel.misc
|
|
|
What date is7 days from given date in Excel 2000
=TEXT(TODAY(),"ddd")
--
** John C **
"GregNga" wrote:
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
|