This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.
Thanks
Tim
Please reconsider changing your rating of my answer. The 1 out of 4 thumbs up is really hurting my overall rating and I was just trying to be helpful here. :( Please do me this one favor and help me out.
Thanks
Tim
Please consider coming back to the site here and changing your thumb rating on my answer, it is really hurting my overall rating. Thanks
×
Hi,
Left me know your email address, I will send a list of excel formulaes with instructions. It will be helpful in future also.
Thanks & Regards,
Anil
You are right. You have to have a table of holidays and then compare the result in this table and then work the new date. Like "if B1 = range (here give the range of the holidays table, just one column is required) then B1 = (B1 - 1). Something on those lines.
I am using Open Office. And what is there in MS Office, OO has to be compatible with it.
If is used as
IF(Test; ThenValue; "OtherwiseValue")
example IF (A1 <> value; B1 10 ; B1 9)
Now the value of 'value' should be specified and can not be taken from the range in OO. I am not sure about MS Office. To achieve this we will have to use IF operator that many times as are the holidays with the operator OR. Example
IF(A1 <> value1; B1 10 ; B1 9) OR
IF(A1 <> value2; B1 10; B1 9)
These are just two conditions. You can have as many as you want as are the holidays.
Else you can try the range. It may work, you never know.
×
369 views
Usually answered in minutes!
would u show me the excel formula in B1 (e.g. =ifB1+14=range(A1:A20)...) and the holiday table we just need to input all holidays in one column?
Require to write an MS excel formula,
Input a date in cell A1, write a excel formula in cell B1 to display A1 + 14 days & exclude holidays if B1 result is a holiday, i think we need to create a holiday table in other worksheet, everytime calculate cell B1 need to check holiday table, example 1, cell A1 input 1 Sep 2010, cell B1 display 15 Sep 2010 because 1 Sep + 14 days = 15 Sep & 15 Sep is not a holiday, sample 2, cell A1 input 1 Sep 2010, cell B1 display 14 Sep 2010 because 1 Sep + 14 days = 15 Sep & 15 Sep is a holiday in holiday table.
Dear Anibr,
My email address is yywong28@yahoo.com.hk
Best regards,
Hello,
Do you receive my email address, would u kindly provide your solution to me as early as possible because i've another excel question need to solve, Fixya request me to solve all previous question then allow me to post another question.
Thank you for your support!
Best regards,
Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a holiday then the date display in B1 will be back day) Case 1, A1 input 1 Sep 10 then cell B 1 will display 15 Sep 10 because (A1 + 14 days = 15 Sep 10 and 15 Sep 10 is a working day). Case 2, A1 input 1 Sep 10 then cell B 1 will display 14 Sep 10 because (A1 + 14 days = 15 Sep 10 but 15 Sep 10 is a holiday therefore B1 cell will back day to a non holiday day). I think we need to create a holiday table to pre-set the date in other worksheet, check the holiday table before display the result in cell B1.
×