How to determine the weekday in excel?
 

You maybe able to modify the function I used to get the dates of each weekend
of the month. R16 was the date, the second function was to get the next week
end in that month.

=IF(WEEKDAY(DATE(YEAR(R16),MONTH(R16),1))=7,(DATE( YEAR(R16),MONTH(R16),1)),7-WEEKDAY(DATE(YEAR(R16),MONTH(R16),1))+DATE(YEAR(R1 6),MONTH(R16),1))

=IF(WEEKDAY(DATE(YEAR(R16),MONTH(R16),1))=7,(DATE( YEAR(R16),MONTH(R16),1)),7-WEEKDAY(DATE(YEAR(R16),MONTH(R16),1))+DATE(YEAR(R1 6),MONTH(R16),1))+7

You would only have to change what it is = to for deference days of the month.

yojinbou


"Eric" wrote:

Does anyone know on how to determine the date for weekday? such as
Today is wednesday 29 Nov, and I would like to determine the date by adding
11 working days from today, but not include today, and exclude all saturday
and sunday.
The answer is 14 Dec.
I will input the number of working day [11] in cell A1, and the 14 Dec is
displayed on B1.
Does anyone have any suggestion on how to code it in excel?
Thanks for any suggestions
Eric