Hi,
Lurked for a while and afraid my first post is asking for help!
This is something probably stupidly simple but baffling me trying to come up with a solution!
Basically I need to add a column to my source data so I can use it as a filter on my Pivot Table in a different workbook. - something just as simple as TRUE/FALSE if the date is YTD for all years would be ideal.
Found a simple solution looking at just the month but need it down to a daily level!
Have attached an example if that makes it any clearer! nice simple formula would be ideal as sheet is around 600,000 rows long and growing!
Thanks in advance
Bookmarks