|
|
Theim,
I am not familiar with creating these functions..but I would like to be
...how would I?
Thank you.
"Thiem" wrote in
message ...
12/05/06 =WEEKDAY(A2,1) =VLOOKUP(B2,$A$11:$B$17,2,FALSE)
13/10/05 =WEEKDAY(A4,1) =VLOOKUP(B4,$A$11:$B$17,2,FALSE)
12/05/04 =WEEKDAY(A6,1) =VLOOKUP(B6,$A$11:$B$17,2,FALSE)
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
1 Sunday
First read the Weekday Fuction to understand, If you start your week on
a Sunday, the ref to enter will be 1, meaning 1 will be first day of the
week or Sunday. Then you just do a vlookup as list above
Cheers
A
--
Thiem
------------------------------------------------------------------------
Thiem's Profile:
http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=475514
|