Hello,
I have the following file that has the Date field coming from a Red Hat Linux environment and comes into excel as a.csv extension. I saved the file as an excel workbook and am trying to evaluate a IF statement where the Date will be ignored if the date in the cell is >Nov 2025 or
How do I then either a) mass convert the native Date Column to a Date format or b) create a helper Column B pointing to Column A: (text(A2, "MMM YY"), copying and pasting as values and then changing it to Date format with custom date convention of mmm yy. Here is the link to the file:
https://docs.google.com/spreadsheets/d/1zYTGXGtvwCDWhhZp6yoDfnyH4zSDTYAk/edit?usp=drive_link&ouid=103354753371375324640&rtpof=true&sd=true
Is there a workaround to the Date column so that excel evaluates is as a true date (serial) data? Thank you.
Regards,
Shams.
techcommunity.microsoft.com
techcommunity.microsoft.com
Create attached notes ...
