Tom Urtis / Atlas Programming

Using VLOOKUP to return sequential results from multiple lookup values. #TomsTips4Excel

Counting holidays and dates of observance between specified dates. #AskTomUrtis

Formatting to color and bold a specified word in all cells' constant strings. #TomsTips4Excel

Formatting a comment shape's individual lines of text with a different color. #AskTomUrtis

Counting a specified month in a list of dates, and unique dates in a specified month. #AskTomUrtis

Summing positive times only, and alternate methods for calculating and summing negative times only.

Calculating Father's Day dates for future years, in America for this example which happens this weekend.