Today's date minus one day, except weekends. I.e Monday = Friday

[goodquestionmma]

Please can someone tell me the formula for Today's Date - one day. On Monday's it will revert to the previous Friday.

For instance: Today is Monday 13/01/2020 (DD/MM/YYYY)

Formula will display 10/01/2020

Or

Today is Friday 10/01/2020

Formula will display 09/01/2020

Many thanks

[Pepe Le Mokko]

Try the WORKDAY function

[goodquestionmma]

=WORKDAY(TODAY(),-1,0)

Worked.

Thank you for your help.

[Pepe Le Mokko]

You're welcome