Auto dates for 2 days

[Patcheen]

Im trying to create a formula to give me dates for only 2 days of the week Tuesday and Friday every week

example -
7.11.23 (Tuesday)

10.11.23 (Friday)

14.11.23 (Tuesday)

17.11.23 (Friday) so on and so on as i only dates for these days

 

[awoohaw]

What is your reference for the day, try this assuming today as the start date:

Mr Excel Questions 72.xlsm
	A	B
1	Start Date	Tue 2023-Nov-07
2		Fri 2023-Nov-10
3		Tue 2023-Nov-14
4		Fri 2023-Nov-17
5		Tue 2023-Nov-21
6		Fri 2023-Nov-24
7		Tue 2023-Nov-28
8		Fri 2023-Dec-01
9		Tue 2023-Dec-05
Patcheen

Cell Formulas
Range	Formula
B2:B9	B2	=WORKDAY.INTL($B$1,ROWS($B$2:B2),"1011011")

 

[Fluff]

How about

Fluff.xlsm
	D
1	01/11/2023
2	03/11/2023
3	07/11/2023
4	10/11/2023
5	14/11/2023
6	17/11/2023
7	21/11/2023
8	24/11/2023
9	28/11/2023
10
Data

Cell Formulas
Range	Formula
D2:D9	D2	=WORKDAY.INTL(D1,SEQUENCE(8),"1011011")
Dynamic array formulas.

Change the 8 to however many dates you want.

 

[alansidman]

Assume start and end dates in A2 and B2 then with Power Query. Change the values in those cells and click on Refresh All and your output is updated.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Start", Int64.Type}, {"End", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Tuesday/Friday", each {[Start]..[End]}),
    #"Expanded Tuesday/Friday" = Table.ExpandListColumn(#"Added Custom", "Tuesday/Friday"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Tuesday/Friday",{{"Tuesday/Friday", type date}}),
    #"Inserted Day of Week" = Table.AddColumn(#"Changed Type1", "Day of Week", each Date.DayOfWeek([#"Tuesday/Friday"]), Int64.Type),
    #"Filtered Rows" = Table.SelectRows(#"Inserted Day of Week", each ([Day of Week] = 2 or [Day of Week] = 5)),
    #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Tuesday/Friday"})
in
    #"Removed Other Columns"

 

[Patcheen]

Thank you to you all for your help problem sorted thank you so much

 

[Fluff]

Glad we could help & thanks for the feedback.