I need someone to write a formula for converting daily data to monthly data. I can only download the data in a daily format and the daily date doesn't always correspond to the last day of the month. I'm sure this is quite simple for someone with more advanced formula expertise (e.g., INDEX-MATCH).