I was looking for a method that mentions the date if it is a working day
I have a list of 12 Dates as below
Please note that I have not mentioned Saturday and Sunday as it is a Holiday
I have not mentioned 26-01-23 as it is holiday here in India
Now starting from last date mentioned ie. 07-02-23 I wanted to create a formula that mentions 1 day earlier than today, For Eg. today is 08-02-23, and 1 day early it should mention 07-02-23, if it is a working day else the previous date should be mentioned. ( For. Eg. If Previous Day is Sunday it should Take Friday as Saturday is a holiday )
Then go to 06-02-23 that is 1 day early from 07-02-23
Now see 03-02-23, here 4th and 5th is Saturday and Sunday so it is not mentioned so it took date as 03-02-23.
I need this as I have to change the date every day for getting the latest price for last 12 days.