Hi Excel Forum,
I am working with surface water data along a river that contains (date and discharge in CMS). One way to look at this data is seasonally. the data is recorded per day for 50 years. Id like to make a column that is seasons based on the month.
so when you use the macro it will look at the stream gage date then fill the season column (winter, spring, or Monsoon).
winter = 11/1/xxxx to 2/xxxx
spring = 3/1/xxxx to 6/30/xxxx
monsoon = 7/1/xxxx to 10/30/xxxx
any help towards this would be great.
ive attached the data and have filled the first year seasons manually for an example.
Bookmarks