ExcelBanter - View Single Post - Display yesterday's date but only for weekdays?

Ron Rosenfeld[_2_]

On Thu, 15 Nov 2012 05:50:26 -0800 (PST), wrote:

On Tuesday, July 21, 2009 6:08:02 PM UTC+5:30, Gary''s Student wrote:
=TODAY()-CHOOSE(WEEKDAY(TODAY()),2,3,1,1,1,1,1,1)
--
Gary''s Student - gsnu200859

"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

THIS WORKS :) !

You could also use =workday(today(),-1)
If you are using a version of Excel prior to 2007, and receive the #NAME! error, look at HELP for the WORKDAY function for instructions on installing the Microsoft Analysis ToolPak