Thread
:
Date of the First Friday every month
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
Date of the First Friday every month
Hi,
Am Thu, 12 Jan 2017 02:39:11 -0800 (PST) schrieb
:
i did the second choice and copied the formula and referenced it to data validation list
thank u alot
now i can use it with any day by changing the day reference number ,right?
=DATUM(C2;1;1)-REST(DATUM(C2;1;1)-2-5;7)+7*1-1
^^
you have to change that number
1 for Monday, 2 for Tuesday, and so on, 5 for Friday
Regards
Claus B.
--
Windows10
Office 2016
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch