Weekday formula problems

[jrschaef]

I have entered a formula and it works fine in my excel sheet that I have saved, but when I send it out to others through email and they open the sheet the formula gives the a #NAME error. Why would this be and what do I need to solve this?

The formula is

=Weekday(Today(),-1)

 

[Joe4]

Isn't WEEKDAY from the add-in Analysis Toolpak?

No. Maybe your were thinking of WORKDAY?

 

[jrschaef]

What I'm trying to get with this function is the last weekday. I used to use Today()-1, but this does not work on Mondays. It returns Sundays date, and I want it to return Fridays (the last workday). That's why I was using the -1. What should I use instead of this? And actually now that I look at my formula, I did use workday vs weekday.

Thanks,
Jamie

 

[Joe4]

It sounds like you may actually want the WORKDAY function, i.e.

=WORKDAY(TODAY(),-1)
will give you the date of yesterday's workday

If you want it in the WEEKDAY format, use:
=WEEKDAY(WORKDAY(TODAY(),-1))

Be sure to have the Analysis Tool-Pak add-in loaded and enabled to use this function.

 

[Cbrine]

=IF(ISERROR(VLOOKUP(WEEKDAY(TODAY(),1)-1,C2:D8,2,FALSE)),"Sat",VLOOKUP(WEEKDAY(TODAY(),1)-1,C2:D8,2,FALSE))

with a vlookup table of
1... Sun
2... Mon
3... Tue
4... Wed
5... Thur
6... Fri
7... Sat

This should give you the results you are looking for.