2 Replies Latest reply: Jan 17, 2013 11:14 AM by Ismael Villegas II RSS

    Adding a Flag to Holidays

    Ismael Villegas II

      QV Community,

       

      I have a list of company holidays that I would like to join to a table containing daily sales statistics. I am planning to perform an analysis on our sales performance on days that fall on those holidays, the day before the holiday and the day after a holiday. I am familiar with the firstworkday and lastworkday functions so I am able to calculate those dates. What would be the best way to flag these dates?

       

      I was hoping that someone could provide some advice on how to do this.

       

      Thank you