Greetings All,
I'm trying to use instr to isolate the day part of a date
Dim BegDate As String
BegDate = Range("B3").Value
modBegDate = InStr(1, BegDate, ? )
the value in BegDate is "3/1/2014 3:35:09 PM" What I want to isolate is the day "01"
Question - the value in cell B3 is format type Custom. Does that make a difference?
thank you
I'm trying to use instr to isolate the day part of a date
Dim BegDate As String
BegDate = Range("B3").Value
modBegDate = InStr(1, BegDate, ? )
the value in BegDate is "3/1/2014 3:35:09 PM" What I want to isolate is the day "01"
Question - the value in cell B3 is format type Custom. Does that make a difference?
thank you