Formula logic help

[NiranjanK1]

Hi All, Please help me to build the below logic

EDate:-

If Today is Monday then EDate Include(Today-3,Today,Today+1) - Friday,Sunday,Suturday,Monday and Tuesday for EDate Report.

If Today is Friday then EDate Include(Today-1,Today,Today+2)- Thurday,Friday,Suturday and Sunday, Monday for EDate Report.

If Today is Tuesday Then EDate Include(Today-1,Today,Today+1) - Monday, Thesday, Wednesday for EDateReport.

PDate:-

If Today is Monday then PDate Report is (Today+2) Wednesday.

If Today is Friday then PDate Report is Exclude(Suturday and Sunday) is (Today+2) Tuesday.

RunDate	EDate	PDate	ExpectedOutput
3/3/2023	3/3/2023	3/22/2023	EDate Report
3/3/2023	3/3/2023	4/5/2023	EDate Report
3/3/2023	2/23/2023	3/7/2023	PDate Report
3/3/2023	3/3/2023	4/3/2023	EDate Report
3/3/2023	3/4/2023	4/11/2023	EDate Report
3/3/2023	3/5/2023	4/4/2023	EDate Report
3/3/2023	3/6/2023	4/20/2023	EDate Report
3/3/2023	3/3/2023	3/30/2023	EDate Report
3/3/2023	2/20/2023	3/7/2023	PDate Report
3/6/2023	3/3/2023	3/30/2023	EDate Report
3/6/2023	3/4/2023	3/31/2023	EDate Report
3/6/2023	3/6/2023	3/21/2023	EDate Report
3/6/2023	2/17/2023	3/8/2023	PDate Report
3/6/2023	3/6/2023	4/14/2023	EDate Report
3/6/2023	3/6/2023	3/28/2023	EDate Report
3/6/2023	2/21/2023	3/8/2023	PDate Report
3/6/2023	3/5/2023	3/22/2023	EDate Report

[binuacs]

@NiranjanK1 can you explain this logic "If Today is Monday then EDate Include(Today-3,Today,Today+1) - Friday,Sunday,Suturday,Monday and Tuesday for EDate Report.? it is confusing

[FrederikE]

@NiranjanK1,

I am not sure about your logic. E.g. what is with the other weekdays? But here's how you could approach it: 

[NiranjanK1]

@binuacs 

If Today is Monday then In EDate In have to consider - Friday,Sunday,Suturday ( Today-3) and Monday (Today) and Tuesday (Today+1)

I have to tag all these dates to One New filed saying that these belongs to todays report. 

[binuacs]

@NiranjanK1 Sorry, I completely did not understand the requirement. I have attached a sample workflow with your input data, may be based on that you can give me some expected output would be easier for me to complete the requirement

you can see all the days now (today, EDate Day and PDate_Day). 

[NiranjanK1]

@binuacsthank you, i will check and update