Results 1 to 4 of 4

Thread: Extract weekday from a date

  1. #1

    Default Extract weekday from a date

    I can't figure this out. I know you can do it in excel - but if I want to analyze if a date is a given day of the week e.g. Friday, how do I do that?

  2. #2


    I just had an idea. Though ideally there would be a function for this, I just need to know what one arbitrary date is and then do a dateSubtract, divide by seven and use the remainder.

  3. #3
    Lavastorm Employee
    Join Date
    Apr 2014
    Boston, MA


    Hi, Daniel! Take a look at the 'weekday' function. It gives you values of 0-6 given a date (0 is Sunday).

  4. #4


    What? How did I miss that? I looked through the online help, I looked through the date/time functions listed in the right click menu.


    Thanks Roger!

Posting Permissions

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