Forum Discussion
Excel dates are transposing day and month
I have dates in one of my Excel columns that transposing the day and month on some lines and I can not fix it.
It completed the document partly in Mexico and partly in the US. I can’t change the dates displaying day month year to month day year. Any suggestions?
Can you distinguish between the rows completed in Mexico and those completed in the USA? If so, it might be possible to correct them using a formula or VBA. Otherwise, you're left with a messy situation...
- Yes I can tell.
Let's say you have dates in D2 and down. In another column, use a formula like
=IF(entered_in_Mexico, DATE(YEAR(D2),DAY(D2),MONTH(D2)),D2)
where entered_in_Mexico is some kind of criteria.
lets say the date in B2 reads 11/1/2022
and I want to change it to: 1/11/22
How would I write the formula in column H which is empty?