Quote:
Originally Posted by macropod
You could use:
For a dynamic formula that updates daily, you could use:
Quote:
|
=TODAY()-1-(MOD(TODAY(),7)=2)*2
|
For a formula that references the date in another cell, you could use:
|
=TODAY()-1-(MOD(TODAY(),7)=2)*2
Thank you so much for your help. If you have a chance, would you please explain this formula in layman's terms?
Your help is greatly appreciated.
Thank you,
Karen