Thread
:
How do I get the date for the 2nd friday of each month?
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
Posts: 136
How do I get the date for the 2nd friday of each month?
=A1-DAY(A1)+14-MOD(A1-DAY(A1)+1,7)
Regards,
Bernd
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]