IF formula with 3 criterias

[Chaozfate]

Hi, wish to ask if anyone could help me draft a formula for the following case:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Day[/TD]
[TD]Malaysia[/TD]
[TD]Hong Kong[/TD]
[TD]Dealing[/TD]
[TD]Valuation[/TD]
[/TR]
[TR]
[TD]1/1/19[/TD]
[TD]Thursday[/TD]
[TD][/TD]
[TD][/TD]
[TD]Dealing if Friday is either Malaysia or HK Holiday[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/2/19[/TD]
[TD]Friday[/TD]
[TD][/TD]
[TD][/TD]
[TD]Dealing if Monday is either Malaysia or HK holiday[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/3/19[/TD]
[TD]Monday[/TD]
[TD]PH[/TD]
[TD]PH[/TD]
[TD]Actual Dealing[/TD]
[TD]Actual Valuation[/TD]
[/TR]
[TR]
[TD]1/4/19[/TD]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Valuation if Monday is either Malaysia or HK holiday[/TD]
[/TR]
[TR]
[TD]1/5/19[/TD]
[TD]Wednesday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

For Dealing day, the actual dealing day fall on every Monday, but i would like excel to reverse to previous day if the actual dealing day fall on either Malaysia or Hong Kong Holiday (note that Malaysia and Hong Kong has different PH), and to continuously reverse a day if fall on another holiday.

For Valuation day, the actual valuation day fall on every Monday, but i would like excel to move forward to next day if the actual dealing day fall on either Malaysia or Hong Kong holiday, and to continuously move to next day if fall on another holiday.

Thanks in advance.

 

[poizones]

Chaozfate,

Please be more specific with what you need to happen with your data. Can you provide a step by step process to be more comprehensive.

Thank you.

 

[Chaozfate]

Chaozfate,

Please be more specific with what you need to happen with your data. Can you provide a step by step process to be more comprehensive.

Thank you.

Hi Sir,

Apologies for my limitation in expressing my questions and my needs. I am sorry for that, however, i manage to create a lengthy formula to achieve the result i am looking hence there will be no any necessary follows up required on my question above.

I thank you for everyone efforts in trying to help me, but i am fine with my data now.

Appreciated and cheers.