View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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