Hi, i need help with what VB expression should i use if i’d like to: check if an excel cell is formatted as a date (dd/mm/yyyy hh:mm AM/PM) format. Am intending to use this expression inside an IF statement. IF a cell is not formatted as a date… THEN… (format it as date) ELSE… (ignore) Thanks …

Check if an excel cell is formatted as a date

ctkoh December 16, 2022, 11:02am 7

Thank you so much for the quick advice everyone!

With your help i managed to get the solution.