Display yesterday's date but only for weekdays?
OOPS tpyos R'US
Mkie
"Shane Devenshire" wrote:
I hope you don't get a "MAME" error!
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Mike H" wrote:
Hi,
Try this.
=WORKDAY(NOW(),-1)
If you get a #MAME error then
Tools|Addins and check the analysis toolpak.
Mike
"totalnatal" wrote:
Hi,
I have the following function : =TODAY()-1
The problem is that if we're monday it gives me sunday's date whereas
I only want weekdays so in this case friday.
Any idea on how to mod the function to do that?
thanks
|