Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Datepart function (XP)

    I thought that, although DatePart doesn't appear in the list of available functions, it was still available when typed in Excel? Has this 'hidden' function been removed from Excel XP? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Datepart function (XP)

    DatePart is a VBA function, not an Excel worksheet function. There is a worksheet function related to dates that is undocumented except in Excel 2000: the DATEDIF Function.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •