If Statement or Macro Separate Date 1/12/2010

[999HelpPlease]

I want to write an if statement or VBA to separate the day, month and year. Instead of reading 1/12/2010 I want the 1 to appear in one column the 12 to appear in another column and the 2010 to appear in a separate column. One of my concerns is the first number can sometimes be two digits and the second number can sometimes be 1 digit. Any suggestions?

 

[VBA Geek]

have u tried using the vba.DAY, vba.MONTH and vba.YEAR functions?

 

[NeonRedSharpie]

You don't need an if() statement. You can just use DAY(), MONTH(), and YEAR().

 

[999HelpPlease]

I have figured it out thank you.

 

[VBA Geek]

if your date is stored in MyDate

dim MyDate as Date
MyDate = #1/12/2014#
Range("A1").value = day(mydate)
Range("B1").value = month(mydate)
Range("C1").value = Year(myDate)

 

[Gilliam]

I want to write an if statement or VBA to separate the day, month and year. Instead of reading 1/12/2010 I want the 1 to appear in one column the 12 to appear in another column and the 2010 to appear in a separate column. One of my concerns is the first number can sometimes be two digits and the second number can sometimes be 1 digit. Any suggestions?

Are the Dates stored as text or serial numbers?
quick check for serial numbers: Add 1 to date and see if you get the #VALUE Error.