Hi,
I am looking for an Excel non-VBA function formula based on two parameters (workday, and value in reference cell).
If a cell holds the value 10, then a date starting from 24 December is added, but only if this date is a workday.
If this date is not a workday, then it takes the first day before this date that is a workday.
If the cell holds the value 9, then two dates retrochronologically starting from 24 December downward are added, under the same condition that they should be workdays.
If the cell holds the value 8, then three dates retrochronologically starting from 24 December downward are added, under the same condition that they should be workdays.
I started a formula (=IF(AND(E4=10,C5=1),A5,IF(C4=1,A4,""))) but it does not seem to capture the inherently intertwining logic of all the parameters. Do you know a formula that covers all possible options?
Date multiple criteria formula.jpg
This question has also been posted on https://www.mrexcel.com/board/thread...rmula.1206993/.
Bookmarks