Cross-referencing sheets based on date and month of value
I'm attempting to create a cross-sheet formula that inserts a date onto a target sheet depending on whether the month and date on the source sheet are between certain date ranges. More specifically, on my target sheet (let's call it sheet B), I have columns titled Spring Meeting, Summer Meeting, and Fall Meeting. For the spring column, I need it to reference a column titled Meeting Date on my source sheet (sheet A), then insert the date from that column onto sheet B but only if that date is between January 1 and May 15. I do not want it to factor the year into the equation. The same process would be used for the Summer Meeting and Fall meeting columns. A date should be added for the summer meeting column only if it falls between May 16 and August 19, and Fall should only be added to the Fall meeting column if the date on sheet A is between August 20 and December 31.
Any help is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!