Hi - I'm trying to see if there's a function that can produce multiple dates in one cell. For reference, I want to create a spreadsheet for meetings based on frequency. If I have an initial meeting date, is there a function that will give me subsequent quarterly dates for future meetings?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
function to determine next date months
- Thread starter KayCee
- Start date
I'm thinking I would need 3 different columns in order to do this, but, ideally, below is what I would like to see. I'm looking for something that pulls the first set of words (e.g. January '23), the second set of words (if there are any) and the third set (if there are any), into another column so that I can sort by the months and see who all needs a meeting scheduled in a particular month.
Upvote
0
Excel Facts
Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Of that would create a duplicate line if the client has more than one meeting date listed in next meeting.
Upvote
0
Similar threads
- Question
- Solved
