Hey Im getting data from a google sheet for a date and i want it to return it in a specific format. However im having trouble with using the date functions, The input will be raw text:
You’re missing an M.
Try DD/MMM/YYYY.
L
Ive tried both^ the first screenshot has 3, and the second has 2. Neither are working