| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Can Excel add working days to a date to result in another date? | Excel Worksheet Functions | |||
| In excel,how do I change the date to a date 84 days from previous | Excel Discussion (Misc queries) | |||
| How do I sort by date (not days, weeks, months) in Excel 2000? | Excel Discussion (Misc queries) | |||
Linear Mode
