Formula that returns "Weekend" and "Yesterday" from the day it created

Israelinas

New Member
Joined
Dec 25, 2016
Messages
25
Hello,
I have a report that I prepare on a daily basis.
Every day I present the values of the day before ("Yesterday") - compared to the whole month)
Every Monday I present the values of the weekend (from last Friday to Sunday) compared to the whole month.
I am trying to create a formula that will return "Yesterday" for all days from Tuesday to Friday in the specific week, for example today is Tuesday - so I need it to return the day before (the values for Monday - Yesterday - but not all "Monday's" in this month).
and when I am preparing the report on Monday for the weekend, so it will return the last weekend - Friday to Sunday - but not all weekend in the month - just the last one.

I have dates in my report.
Is it possible to create a formula like this?

Many thanks,
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
No one knows a formula that can help me with this issue?
FYI: I didn't respond further because you never provided the other information that I asked for (twice). ;)
Also, the Excel version(s) you are using may determine what the best functions to use to solve this are, which is why I asked you to update you account details to show this. :)
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top