Using Components of date in vba.


Posted by Chris M. on November 13, 2001 10:00 AM

How do I seperate the Day month Year from a cell with the date format to use the individual numbers in an equasion?
I want to write a formula to change the date to a day of the year with the year being the first digit. I know how to do the formula I just need to figure out how do sepperate the date components.

Posted by another Todd on November 13, 2001 10:56 AM

Use the Day() Month() and Year() equations.



Posted by Chris M. on November 13, 2001 11:18 AM

Thanks. Brain just isn't working today.