Re: Specifying certain columns in a row

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

=IF(WEEKDAY(DATE(A2,B2,C2), 2) > 5,"WEEKEND","WEEKDAY")

and just copy down, the cells will update

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kthxbai" <kthxbai.1z73mn_1133161805.8414@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:kthxbai.1z73mn_1133161805.8414@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Hi,
>
> Alright, so I have the following function:
>
>
> Code:
> --------------------
> =IF(WEEKDAY(DATE(2005, 10, 15), 2) > 5,"WEEKEND","WEEKDAY")
> --------------------
>
>
> The year, month, and day are in the 3 columns preceeding the
> "Weekend/Weekday" column.
>
> How would I go by specifying that the function should take the year,
> month, and day from columns B, C, and D, but -within that row-(so I can
> simply apply the same function to the entire column and not have to
> enter the date data manually in each row)? Can I?
>
> Any help would be greatly appreciated.
>
>
> --
> kthxbai
> ------------------------------------------------------------------------
> kthxbai's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=29140
> View this thread: http://www.excelforum.com/showthread.php?threadid=488579
>


.

Relevant Pages

  • Re: very hard deleting rows issue
    ... Your sentiments are well meant: ... >>> HTH ... >>> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: SUMIF where values to be summed are formula
    ... >> HTH ... >> (remove nothere from the email address if mailing direct) ... >>> criteria to be considered in deciding which values are to be added. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Last Saved Date and Time
    ... Did you put the code in ThisWorkbook code module as stated in original ... >> HTH ... >> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: Find last occurance of text in range
    ... > HTH ... > (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Extract Numerics only
    ... > 'Similar to Excel's SUBSTITUTE but using VBScript's perl-like regexps ... > HTH ... > (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.misc)