What date is7 days from given date in Excel 2000
 

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

What date is7 days from given date in Excel 2000
 

=A2+7

"GregNga" wrote:

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

What date is7 days from given date in Excel 2000
 

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

What date is7 days from given date in Excel 2000
 

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

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

What date is7 days from given date in Excel 2000
 

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" wrote:

=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

What date is7 days from given date in Excel 2000
 

I was just giving an example of the layout, in your specific case, you would...
D2: =TEXT(A2,"ddd")
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"GregNga" wrote:

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" wrote:

=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

What date is7 days from given date in Excel 2000
 

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

"John C" wrote:

I was just giving an example of the layout, in your specific case, you would...
D2: =TEXT(A2,"ddd")
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"GregNga" wrote:

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" wrote:

=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

What date is7 days from given date in Excel 2000
 

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

"GregNga" wrote in message
...
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" wrote:

=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

What date is7 days from given date in Excel 2000
 

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

"David Biddulph" wrote:

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

"GregNga" wrote in message
...
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" wrote:

=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

What date is7 days from given date in Excel 2000
 

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)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"GregNga" wrote:

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

"John C" wrote:

I was just giving an example of the layout, in your specific case, you would...
D2: =TEXT(A2,"ddd")
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"GregNga" wrote:

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" wrote:

=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

What date is7 days from given date in Excel 2000
 

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.
--
David Biddulph

"GregNga" wrote in message
...
John C has answered my question, see his most recent post

"David Biddulph" wrote:

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

"GregNga" wrote in message
...
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" wrote:

=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

What date is7 days from given date in Excel 2000
 

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

What date is7 days from given date in Excel 2000
 

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

"Bernard Liengme" wrote:

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