Determining the Sunday date of the third "full" weekend of a month

[Bernd P]

Hello Bob,

Dates are just integer numbers in Excel.

For a general solution of first (or last) workdays of a given month
see
http://sulprobil.com/html/weekday_in_month.html
please.

Regards,
Bernd

 

[Bob]

Hi Bernd,

Sorry, I should have been more specific in my comment. While I am aware
that dates are just integers, I still do not understand how the FLOOR's
"Significance" parameter works when used with dates. Can you elaborate?

Thanks,
Bob

 

[barry houdini]

Note that the formula

=FLOOR(DATE(B1,A1,21),7)+1

will return a Saturday date if you're using 1904 date system.....

 

[Bernd P]

Hello Bob,

FLOOR(x,7) rounds x down to the next number divisible by 7. For non-
negative numbers it is the same as x-MOD(x,7). I just use it as a
short cut.

Regards,
Bernd

 

[Bernd P]

Hello Barry,

I do not support the 1904 date system.

Please see entry #7 of my Excel Don'ts:
http://sulprobil.com/html/excel_don_ts.html

Regards,
Bernd

 

[Bob]

Bernd,

Thanks for the additional info, and for all your help.

Regards,
Bob

 

[Bernd P]

Hello Bob,

You are welcome. Thanks for your feedback.

Regards,
Bernd