What date is7 days from given date in Excel 2000

[GregNga]

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

 

[Mike]

=A2+7

 

[Bernard Liengme]

Regardless of Excel version: =A2+7 and format as date
If you meant 7 workdays: =WORKDAYS(A1,7)
best wishes

 

[GregNga]

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

 

[John C]

=TEXT(TODAY(),"ddd")
--
** John C **

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

 

[GregNga]

Actually, what I need is to have cell D2 to be the day of the week of the
date in A2. So, if A2 contains 16-Nov, D2 would contain SUN, if A2 contained
17-Nov, D2 would be MON, etc

Sorry for the confusion

 

[John C]

I was just giving an example of the layout, in your specific case, you would...
D2: =TEXT(A2,"ddd")

 

[GregNga]

That answers my question. Could you explain how that works. I know
TEXT(A2,"ddd") converts the value in A2 to text format. What does the "ddd"
tell it?
Thanks

 

[David Biddulph]

So what cell reference might you think of using in the formula in place of
TODAY() ?

 

[GregNga]

John C has answered my question, see his most recent post

 

[John C]

If you read up on the TEXT function, it's syntax is as follows:
=TEXT(value,format_text)
The value would be whatever value you are trying to format a specific way,
in your case, the value in cell D2.
The formatting that you want to achieve needs to be enclosed in quotes. If
you go to Help in excel, and search for help in regards to create custom
format, then create custom number format, format codes, then date and times,
you will see the choices as follows
d = day of the month with no leading zero (i.e.: 1, 2, 3...)
dd= day of the month with leading zero (i.e.: 01, 02, 03...)
ddd=day of the week in short format (Sun-Sat)
dddd= day of the week in long format (Sunday-Saturday)

 

[David Biddulph]

Yes. If there is an Excel function which you don't understand, it's always
worth looking it up in Excel help (unless the function is DATEDIF, in which
case you need to look elsewhere). Help will usually give you the syntax,
show you examples, & often give a useful "See also" link for related
functions.

 

[Bernard Liengme]

If the cell holds a date, why not use a custom format of 'ddd' or 'dddd' to
get Mon or Monday

 

[GregNga]

That seems to work also. Since I want to have both a column with the date and
a column with the day of week, I can just make a copy of the date column and
change the format to 'ddd'. Thanks again