locked
how to "build" a date in VBA RRS feed

  • Question

  • Hi

    Could you recall me how to "build" a date when we know the three attributes : Month, Day, Year? so that this date can be used in calculations !

    Thanks for your help


    • Edited by WLID1966 Tuesday, October 10, 2017 1:37 PM
    Tuesday, October 10, 2017 11:28 AM

Answers

  • Hi Wlid,

    DateSerial(2049, 12, 31)

    Regards
    Barbara

    • Marked as answer by WLID1966 Tuesday, October 10, 2017 3:29 PM
    Tuesday, October 10, 2017 3:18 PM

All replies

  • Hi Wlid,

    DateSerial(2049, 12, 31)

    Regards
    Barbara

    • Marked as answer by WLID1966 Tuesday, October 10, 2017 3:29 PM
    Tuesday, October 10, 2017 3:18 PM
  • Thanks a lot !
    Tuesday, October 10, 2017 3:30 PM