Agnus Dei (jackal) wrote,
Agnus Dei
jackal

Excel Function to Display Weekends (TRUE/FALSE)



=WEEKDAY(D4,2)>5


Where in this case D4 was my date field.    If it returns a number greater than 5 (6 or 7) it's Saturday or Sunday.

Then you a conditional function (classic) to make it colored RED on True.  :)

Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

  • 0 comments