Converting Date to String 1

[Josh01]

Hi all,

I have a date in the format "yyyy/mm/dd" that is a dynamic value. Depending on what the date is, i want a cell within another sheet to reflect the full name of the month plus a two year code. I.E. January 02.

Can anyone help me to do this please????

 

[Jon4747]

Hi Josh,

Dim intA As Date
intA = "2002/01/18"
Debug.Print Format(intA, "mmmm yy&quot
'output will read January 02

Jon

 

[Josh01]

Jon,


Thanks for that, as it turned out I managed to use a work around. Which, unfortunatly led to another problem. I now have two dates in the format that i would like them, which is now dd - mmmm - yyyy!, however i need to work out the number of work days between these dates, which are dynamic. Any ideas?

Cheers

 

[Jon4747]

Hi Josh,

Try using the DateDiff() function
Days = DateDiff("d",date1,date2)

Jon