Hi,

I am working in reconciliation and I always work 1 day behind. I need to display the previous date in my work. Usually I will input:

=TODAY()-1

But if it is Monday, it will display Sunday.

1. Is there any code that will display as Friday instead?

2. If Monday is a holidays and we are Tuesday. I will have to display Friday too, so what code can we input for this one?

Best Regards,