| 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
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 |
|
#9
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 |
|
#10
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) | |||
Hybrid Mode
