IF/AND Function with WORKDAY.INTL

[ValyrianSteel]

Hi All,

Me again with another query I can't seem to solve!

I have previously posted the thread the below and got an answer which solved the problem.

If function using dates to only return dates on a Monday

I am now looking to amend the formula to take the baseline (Column AR) into consideration. So if the baseline is after the lease forecast or the actual (columns AK/AL) then it would use the baseline date. All while keeping the original formula of only starting on a Monday working

Any help would be great!!!!

 

[jasonb75]

Something like

=WORKDAY.INTL(MAX(AR102,IF(AL102="",AK102,AL102))+42+AP102+1,-1,"0111111")

 

[ValyrianSteel]

Something like

=WORKDAY.INTL(MAX(AR102,IF(AL102="",AK102,AL102))+42+AP102+1,-1,"0111111")

Pretty much spot on!! Needed an extra bracket to but that is all!

=WORKDAY.INTL(MAX(AR44,(IF(AL44="",AK44,AL44)))+42+AP44+1,-1,"0111111")

Thank you!!! Have a great day!

P.S If you amend your post I can mark as solution? Don't want to mark my own that is all

 

[jasonb75]

Needed an extra bracket

The extra pair of brackets that you added to the formula don't actually serve any purpose, the formula will work the same without them.