| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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  . Ithelps 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" <(E-Mail Removed)> wrote in message > > > > news:332EC5A1-34F2-4C18-B0A5-(E-Mail Removed)... > > > > > 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 > > > > > > > > > > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message > > > > > news:332EC5A1-34F2-4C18-B0A5-(E-Mail Removed)... > > > > > > 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 > > > > > > > > > > > > > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| To-days date in Header or Footer - Excel 2000 | Abay | Microsoft Excel Discussion | 3 | 4th May 2007 11:58 PM |
| Re: Excel Formula to calulate number of days passed from date to date | Dave Peterson | Microsoft Excel Misc | 2 | 4th Jan 2007 11:27 PM |
| Re: Excel Formula to calulate number of days passed from date to date | Nick Hodge | Microsoft Excel Misc | 0 | 4th Jan 2007 09:17 PM |
| Re: Excel Formula to calulate number of days passed from date to date | Roger Govier | Microsoft Excel Misc | 0 | 4th Jan 2007 09:14 PM |
| How do I sort by date (not days, weeks, months) in Excel 2000? | =?Utf-8?B?VG9ueQ==?= | Microsoft Excel Misc | 1 | 21st Jan 2005 03:28 PM |
