What date is7 days from given date in Excel 2000

G

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
 
B

Bernard Liengme

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

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
 
J

John C

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

GregNga said:
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
Click to expand...
 
G

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
 
J

John C

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

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
 
D

David Biddulph

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

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)
 
D

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.
 
B

Bernard Liengme

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

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
 
Top