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