Multiple formulas in same cell

[c.clavin]

Hey guys, new to Excel, new to these forums!

I have a problem writing a formula out for 1 cell.
On 1 hand, I need to make a formula that 1 cell is 2 workdays after another cell (=WORKDAY(D11,2, '*'!B2:B15) but I also have a time requirement, where if it is after 4:30pm it needs to be 3 workdays after the other cell, due to processing issues.

I have a formula, pointing to a different cell in case it is after 4:30 (=IF(NOW()>1630,D11+3)

How do I couple these 2 formulas into one cell so I dont have to make 2 different boxes? Any help would be appreciated. It aggravates me that both work, but I cant incorporate them together. This forum is the best!

 

[T. Valko]

Thank you so much for all of your help. You have made my spreadsheet from good to unbelievably good with the few formulas you've given me. I actually bought an Excel how-to book, but it barely scratches the surface of what there is to know.
My question is, in your formula, is there anyway to create exceptions to the rules outlined? If on say March 27th, if instead of skipping 3 days (weekend) if you wanted that particular date to skip say 5 days, is there anyway to write an exception for a few days out of the year? There are oddities that come up, and this would 'unturn' every 'odd' 'stone for the spreadsheet. I really appreciate all of your help, would you recommend any books to me for future learning? Thanks again, and have a great rest of the weekend.

You should be able to account for those dates if you already know what those dates are.

List those dates in a range of cells, say A2:A5.

Then the formula becomes:

=WORKDAY(D11,IF(COUNTIF(A2:A5,D11),5,2+OR(MOD(NOW(),1)>TIME(16,30,0),WEEKDAY(D11,2)>5)),Holiday_List)

Where Holiday_List is the range of cells that holds the holiday dates to be excluded.

 

[T. Valko]

would you recommend any books to me for future learning?

Here's a good compilation of Excel books:

http://contextures.com/xlbooks.html

I haven't actually read any of them so I don't know if they cover the kind of info you're looking for.

I think the best way to find a book for your needs to go to a book store and have a look see. Thumb through the offerings and see if they are what you want.

I was in a Border's Express a couple of weeks ago and looked to see what they had on Excel. They had lot's of stuff on VBA programming and general "how to" stuff but nothing specifically on formulas.