Specifying certain columns in a row

K

kthxbai

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.
 
B

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top