Show last working day.

[shadow12345]

Hi,

I am currently using =today()-1 to get yesterdays date, and it works fine... until Mondays When i get Sundays date when I want Friday's.

is there a way to have the last working day's date? (Monday to Friday only) so on Monday I get Fridays date.

 

[VoG]

Try

=WORKDAY(TODAY(),-1)

In Excel 2003 and earlier this requires the Analysis ToolPak from Tools > add-ins.

 

[shadow12345]

ahhhh thats done it thanks... I was playing with Weekday but couldn't get it to work.