Hi,

I am looking to create a formula (ideally in Excel, but VBA could also work), that would given me the maximum value in column B for the dates between today and the following 45 calendar days.

Column A Column B
January 20, 2015 11.78
January 21, 2015 11.85
January 22, 2015 11.99
January 23, 2015 11.68
January 26, 2015 11.78
January 27, 2015 11.82
...

Not every day will have a set of values as weekends and holidays won't have records. In the example above I assume January 24 and January 25 are weekend days.

Thank you.