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,
Bookmarks