Some add on explanation :D
WEEKDAY( serial_number, [return_value] )
serial_number is a date expressed as a serial number or a date in quotation marks.
return_value is optional. It is the option used to display the result. It can be any of the following values:
Value Explanation
1 Returns a number from 1 (Sunday) to 7 (Saturday). This is the default if parameter is omitted.
2 Returns a number from 1 (Monday) to 7 (Sunday).
3 Returns a number from 0 (Monday) to 6 (Sunday).
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Mikebra 
Register To Reply
Bookmarks