Hi guys,
Not sure if this can be done in a formula or if it will need a macro but I've got the following happening on a sheet:
Column A: List of entries
Column B-L: future dates for each of the values in column A
What I'd like to happen is a formula where if the current year and a year in one of the dates match then the value from column A will be displayed.
So if I look at a sheet it automatically lists the different entries in column A that are 'due' this year..
Hope this makes sense. Any further clarification please do get in touch!
Thanks a lot!
Bookmarks