Hello StefanIs there a way to automate this formula that I use to calculate the date of a specific day in a month (2nd Tuesday, 4th Friday etc)
=$B$5-DAY(B5)+1+D5*7-WEEKDAY(B5-DAY(B5)+8-C5)
=$E$5-DAY($E$5)+1+LEFT($E$8,1)*7-WEEKDAY($E$5-DAY($E$5)+8-VLOOKUP(MID($E$8,FIND(" ",$E$8)+1,3),$B$5:$C$11,2,FALSE))
Hello Lutfor, That's perfect, thank you very muchIs there a way to automate this formula that I use to calculate the date of a specific day in a month (2nd Tuesday, 4th Friday etc)
=$B$5-DAY(B5)+1+D5*7-WEEKDAY(B5-DAY(B5)+8-C5)
You are most welcome, Stefan.Hello Lutfor, That's perfect, thank you very much