uolymme637
New Member
- Joined
- Jul 17, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi all!
I am looking for help creating a macro that helps with the following:
I have a date field that comes out of my ERP that is in the following format MDDYYYY or MMDDYYYY (Depending on the month). Aka there is no leading zero for Jan-Sept.
I have solved this issue by creating the following formula, when the date is in C3
=IF(LEN(C3)=7,LEFT(C3,1)&"/"&MID(C3,2,2)&"/"&RIGHT(C3,4),LEFT(C3,2)&"/"&MID(C3,3,2)&"/"&RIGHT(C3,4)) - And then doing text to columns to get it formatted to a date
However I would like to create a macro that lets me put this formula in the active cell, but the date that I am using is not always in C3 (It is always in column C). Is there a way I can create a pop up, or tell it to use column C for the row it is currently in?
I am looking for help creating a macro that helps with the following:
I have a date field that comes out of my ERP that is in the following format MDDYYYY or MMDDYYYY (Depending on the month). Aka there is no leading zero for Jan-Sept.
I have solved this issue by creating the following formula, when the date is in C3
=IF(LEN(C3)=7,LEFT(C3,1)&"/"&MID(C3,2,2)&"/"&RIGHT(C3,4),LEFT(C3,2)&"/"&MID(C3,3,2)&"/"&RIGHT(C3,4)) - And then doing text to columns to get it formatted to a date
However I would like to create a macro that lets me put this formula in the active cell, but the date that I am using is not always in C3 (It is always in column C). Is there a way I can create a pop up, or tell it to use column C for the row it is currently in?