I'm really at a loss here as I cannot start my project without first completing this step..
In column 'A' I have dates in YYYYMM format and i'm trying to filter between ranges from YYYY-1/MM to YYYY/MM-1 (where YYYY/MM = current year/current month)
Between current year minus 1 year and then...
I have a large spreadsheet with dates in text format, YYYYMM. I used the Text to Columns option and selected Date YMD. When i attempt to convert the cell to dates it converts 201801 into the year 2452, July. Any suggestions?
Question - I need this to sum to 19 but I can only figure out how to sum to the 6. I think I need a text YYYYMM in my sumif somewhere.