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, 10:31am 4

Hi! Thank you for the fast reply!

Just wondering how do I use this VB expression to check a specific cell in my xlsx file.

I don’t see it referencing any excel file or cell.

Topic		Replies	Views
How to check whether a item in a column is in dd/MM/yyyy format? Studio studio , question , activities_panel	8	1129	April 27, 2023
How to check if a value is a date Help activities , string , question , data_manipulation	5	11579	December 6, 2019
How to Validate date in the format yyyy.mm.dd using vba code Help activities , string , question	8	5173	December 13, 2019
If condition for date Studio excel , activities , studio , question , activities_panel , date , parse	4	767	December 19, 2022
Date format issue in Studio Studio datatable , excel , studio , string , question	7	1023	April 30, 2021