Home > Net >  Date showing as serial number in formula
Date showing as serial number in formula

Time:05-15

I'm currently having an issue with the date format. I have basically extracted the month and year from a standard dd/mm/yyyy date and wish this to be formatted as mmm yyyy ie Jan 2022 for use in a dropdown. This dropdown is then used to filter data using a query formula.

I have broken my sheet down to a 'test' sheet at enter image description here

  • Related