Sign Up ›
  • Sugar Gozom
  • NEWBIE
  • 0 Points
  • Member since 2016
  • Chatter
    Feed
  • 0
    Best Answers
  • 3
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
14 replies

Displaying the Day of the Week From a Date (1900,1,7)

Hi everyone,

I'm new to coding here, I would just like to know why do we need to subtract this value "Date(1900, 1, 7)" to a certain date to get the day of the week? I don't quite understand what's with this date? Eg "MOD( TODAY() - DATE( 1900, 1, 7 ), 7 )".

Thanks for the help.
14 replies

Displaying the Day of the Week From a Date (1900,1,7)

Hi everyone,

I'm new to coding here, I would just like to know why do we need to subtract this value "Date(1900, 1, 7)" to a certain date to get the day of the week? I don't quite understand what's with this date? Eg "MOD( TODAY() - DATE( 1900, 1, 7 ), 7 )".

Thanks for the help.