ExcelBanter - calculate weekdays only

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - calculate weekdays only (https://www.excelbanter.com/excel-programming/311110-calculate-weekdays-only.html)

benb

calculate weekdays only

I am looking for code to insert yesterday's date if yesterday was a weekday,
and to use the previous Friday's date otherwise (if yesterday was Sunday).
Anyone know how to do this? Thanks.

All times are GMT +1. The time now is 05:26 PM.