[Solved] VBA: Day / Date

  • Morning All,


    A simple one (I hope); if I have a date written as (say) 07/10/03 (7th Oct 2003), is there a function that translates this to 'Tuesday'?


    Cheers muchly,


    Graham B

    But I always say luck is where preparation meets opportunity (Justin Langer 23/11/01)

  • have a look at the WEEKDAY xl function in xl which is avalable to VBA via Application.WorksheetFunction.blah blah!


    HTH

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!