Trip Calendar Auto-formatting

Another way.

In the attached there is a copy of sheet 'Calendar' ... 'Calendar (2)'.

Row 1 and 2 includes added countries and Days in location. Rows 2 and 3 existing formula are copied across.

In B8 this formula filled across column AF returns countries as days in location indicate

Formula:

=IF(B7="","",INDEX($B$1:$L$1,MATCH(0,INDEX(--(B7>$B$4:$L$4),0),0)))

Then B8:AF8 copied and pasted into cells B14 and B20.

(Note the merged cells have been removed in row 20. Merged cell should be avoided like the plague. They create havoc in formulas.)

Now as countries are added change the range references in the formula for the countries ... or
create some dynamic named ranges in Name Manager. These will size themselves according to amount of data and save having to edit the formula above.

Please let me know if you are interested in that.