How to convert daily data to monthly in excel

You saved me so much work, thankss

plz suggest for weekly analysis

It's blurry.

have drf Data from 1975 to 2010 and it is divided in 8 table how I can convert these data in single table

Great tool. It saved my time. Thanks!

what to do if we have gridded daily rainfall data...
how to change that data and get mean rainfall of months and mean annual rainfall ??
need help plse

I was expecting monthly data .. not a monthly grouped pivot table. this sucked !

Speak up

you're a life saver, thank you 🙏🏻

Hi, thanks for the video.
Do you know how can I do this when I have multiple points? I mean I have 6000 boreholes, and the daily water level data for them from 2000 to 2020 (all in one excel sheet). Now, I want to create the monthly average data of each borehole in each year. Could you please help me with that?

what about 6 hourly data can i use the same method as this one, if im converting it to seasonal data e.g. DJF

Thank you very much

Could you please tell me from where you got these daily Data for all these years ? thx

Thank you very much🙏🙏