On many occasions we would like to somehow get the dates belonging to the last day of current, previous or any other month, the first day of this month or any day of ...
We have a column of dates in Excel, and our goal is to get Q1, Q2,… or QTR1, QTR2,… or Quarter 1, Quarter 2,… . I think you get the picture 🙂 First we ...
I guess we are all familiar with the MONTH function in Excel. If you give it a date as an argument, it will return the month number. So far so good. But here is a ...