Date and Workday.intl

[jhwilliams1985]

This is 2nd Friday of Feb.
Date: 2/10/2023

Returns First Friday of the current Month.
=WORKDAY.INTL(TODAY()-DAY(TODAY())+1,1,"1111011")

What formila will tell what friday it will land on.
(Want the formila to tell me if it will land on 4/7 or 4/14. The correct date is 4/7)

I could create it this way (Picture), but I would rather not if there is a better way.

 

[Fluff]

Hi & welcome to MrExcel.
Not sure quite what you are asking for. Do you want a formula that will give the date of the 1st Friday in the month?

 

[jhwilliams1985]

Hi & welcome to MrExcel.
Not sure quite what you are asking for. Do you want a formula that will give the date of the 1st Friday in the month?

No, I have a $ amount on Feb 10th, I want it to repeat every 2 weeks on friday.
I am trying to figure out what day the $ amount will show up this month.
Without telling, Excel has every Friday in 1 column and the $ amount in the next column repeating every 2 weeks.

I want a formula to show me what day the $ amount will show up this Month.

 

[Fluff]

Is this what you mean

Fluff.xlsm
	A
1	10/02/2023
2	24/02/2023
3	10/03/2023
4	24/03/2023
5	07/04/2023
6	21/04/2023
7	05/05/2023
8	19/05/2023
9	02/06/2023
10	16/06/2023
11	30/06/2023
12	14/07/2023
13	28/07/2023
14	11/08/2023
15	25/08/2023
16	08/09/2023
17	22/09/2023
18	06/10/2023
19	20/10/2023
20	03/11/2023
21	17/11/2023
Master

Cell Formulas
Range	Formula
A2:A21	A2	=WORKDAY.INTL(A1,SEQUENCE(20,,2,2),"1111011")
Dynamic array formulas.