This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to a filter a date 2 days ahead of today excluding Weekends. For example, If today is Monday then i need to get Wednesday date. If today is Thursday i need to get Monday or if its Friday i need to get Tuesday.
Appreciate if anyone can provide the formula for the above use case.
Thanks for the reply @lmorrell but the solution you provide is not requirement for my use case.
Just to rephrase my use case, i want to a apply a logic wherein if today is Monday then it will give data that has date as of Wednesday which 2 days different. But if today is Thursday or Friday i need to get the data with date as of Monday and Tuesday the following week.