Hi everyone,
I have a worksheet that I'd like to dynamically enter a date into a cell based on the value of another cell.. I would typically just use =LEFT(), but I'm not sure how to do this because it's a text value. I'm already using VBA to submit data to the correct sheets, so I'm guessing that's the easiest way to go.. Here's the necessary info:
Data Input Cell R1 contains the text, always in the form of "3/10/2014 - 3/16/2014"
I'd like the VBA code to input the date (in this case) 3/10/2014 into cell R3 of the same worksheet. I'd assume the best way to do it would be with some variation of the =Date() vba command, but I'm not even really sure where to start with the rest of the code..
I'td be incredibly helpful if someone could point me in the right direction!
Cheers
Hank
I have a worksheet that I'd like to dynamically enter a date into a cell based on the value of another cell.. I would typically just use =LEFT(), but I'm not sure how to do this because it's a text value. I'm already using VBA to submit data to the correct sheets, so I'm guessing that's the easiest way to go.. Here's the necessary info:
Data Input Cell R1 contains the text, always in the form of "3/10/2014 - 3/16/2014"
I'd like the VBA code to input the date (in this case) 3/10/2014 into cell R3 of the same worksheet. I'd assume the best way to do it would be with some variation of the =Date() vba command, but I'm not even really sure where to start with the rest of the code..
I'td be incredibly helpful if someone could point me in the right direction!
Cheers
Hank