I download payroll data then using Get Data transform the raw data into a table with multiple years, 2015 thru 2021.
I want to create a column that will tell me what the payroll number it is for that year, 1 thru 26
January 16, 2015 would be payroll 1 for 2015
January 30, 2015 would be payroll 2 for 2015
January 15, 2016 would be payroll 1 for 2016
January 29, 2016 would be payroll 2 for 2016
I have tried using countifs() with the check date and year column but it doesn't work.
There are 40,000+ rows.
Thanks for reading and hope someone can help.
Lee
I want to create a column that will tell me what the payroll number it is for that year, 1 thru 26
January 16, 2015 would be payroll 1 for 2015
January 30, 2015 would be payroll 2 for 2015
January 15, 2016 would be payroll 1 for 2016
January 29, 2016 would be payroll 2 for 2016
I have tried using countifs() with the check date and year column but it doesn't work.
There are 40,000+ rows.
Thanks for reading and hope someone can help.
Lee