I'm trying to figure out an easy way to use a formula to lay out dates that a business will be open in 2014. It seems like the WORKDAY function would normally be good for this, but this function excludes weekends by default, and our business is open on Saturdays (but not Sundays). Is there an easy way I can exclude Sundays from the formula without excluding Saturdays?
Hi DSwartz,
The link below provides information that maybe helpful to you.
http://office.microsoft.com/en-us/ex...010354380.aspx
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try using the WEEKDAY function within an IF statement, such as
Good Luck!
Please Login or Register to view this content.
Missed that one when I looked at the function list. Looks like it will work great! Thanks!
So I came up with WORKDAY.INTL("1/2/2014",0,11) as my function, which seems to work well. One follow up question: is there an easy way I can increment the "Days" argument (0 in the function currently) without having to manually edit it for every day? It doesn't seem to adjust automatically when I drag down the formula.
I think if you create a small table and reference cells instead of hard-codding you will get what you want.Originally Posted by DSwartz
AlKey, I think I get what you're saying - instead of having "0" in that argument, I should type 0 in cell A1, then A1+1 in cell A2, drag the function out, and then give the argument a relative reference to cell A1? That sounds like it would work, but I swear I read elsewhere on this forum that there was a way I could cause the argument to increment without doing all that. I can't find that thread now, unfortunately. Any other thoughts on how to do this? I like your suggestion, just think there may be a more efficient way.
You can replace 0 with ROW($A1)-1
The ROW($A1)-1 will give you 0 and as you drag your formula down it will change 0 to 1,2,3 etc.
Awesome! Worked great. I keep forgetting about the ROW and COLUMN functions and how useful they can be. Thanks again for your help.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks