Re: What date is7 days from given date in Excel 2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <GregNga@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:332EC5A1-34F2-4C18-B0A5-32A2195E1117@xxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Indian style Number Format
    ... This is from Bernard Liengme ... If you have Excel 2002 or later look up bhattext in help. ... Otherwise the following format might help you ... "Mahesh Kumar K Hegde" wrote in message ...
    (microsoft.public.excel)
  • Re: print contents of a CD
    ... Drag the drive onto the attached file and import the file that appears on the desktop into excel to format it. ... 'Not happy John! ... Defending our democracy', ...
    (microsoft.public.windowsxp.general)
  • Re: What date is7 days from given date in Excel 2000
    ... John C has answered my question, ... "David Biddulph" wrote: ... there a way to have a cell equal to the day of the week in format MON, ... Microsoft Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: Format for making date calculations
    ... I shut down my excel and reopened the program (which I didn't do after I ... changed the date format in the cells) and it seems to be working correctly ... I also changed the date format in the regional settings so I'm not ... "Bernard Liengme" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Links
    ... > Hi John, ... >> I need a word document linked to some tables in Excel. ... I have tried this in the past, but seem unable to format the ... I get a dialog to each Excel file asking if I want to ...
    (microsoft.public.word.vba.general)