Search results

In addition to Hui's reply read this again on ms site: >> WORKDAY(start_date,days,holidays) Start_date is a date that represents the start date. Days is the number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date...

Hui, how would do such a check: I am entering start date and effective date for set of items. I would like to ensure that both startdate and enddate are valid business days (for given region). I was hoping to show the my original entry and the adjusted entry i,e the bumped date next to it. I...

ok. I would expected workday to bump to next work day (not holiday). But I get your point. thanks

Thanks Hui, I apologize, yes it is entered as 1/1/11 and not as text in excel. I know I am doing something silly here - my sincere apologies for taking your time here. **All dates entered as date** 2/11/2011 FRIDAY 02/14/11 WORKDAY(1 DAY) 02/11/11 WORKDAY(0DAY) Holidays 02/11/11...

Thanks Hui, I should have written better: I did have the following: A1 = "01/01/11" B1:B2 = 01/01/11 and 01/02/11 C1 = workday(a1,0,b1:b2) I do not believe c1 gets the valid date beyond 01/02/11. sorry for the bad post earlier. regards

Just one clarification the holiday dates were in a range in the sheet. regards

Hi there, I have workday(1/11/11,0) -> I should get 1/11/11. This seems to work. Now I do workday(1/11/11,0,{1/11/11,1/12/11}) I expect to get 1/13/11 (assuming 13th is not sat/sunday). But I do not believe Excel is skipping to the day past the holiday calendars. Is this a known issue...

I have a string "Buy 100 shares IBM @ 135.90" I would like to display this in a "cell" in excel but Buy should be in BLUE, if Sell then it should be in RED etc. is there a way to do this ? colors are background or foreground is OK. thanks