7 Replies Latest reply: Nov 14, 2011 7:31 PM by John Witherspoon RSS

    Flag every other week

      Is there a way to flag every other week?

       

      Here is an example of what I want to do. Every other week is labeled City. An inline with an if statement of some sort? What function could I use?

       

       

       

      DATEDAYCITY/NON CITY
      1/1/2008TUESDAYNON
      1/2/2008WEDNESDAYNON
      1/3/2008THURSDAYNON
      1/4/2008FRIDAYNON
      1/5/2008SATURDAYNON
      1/6/2008SUNDAYCITY
      1/7/2008MONDAYCITY
      1/8/2008TUESDAYCITY
      1/9/2008WEDNESDAYCITY
      1/10/2008THURSDAYCITY
      1/11/2008FRIDAYCITY
      1/12/2008SATURDAYCITY
      1/13/2008SUNDAYNON
      1/14/2008MONDAYNON
      1/15/2008TUESDAYNON
      1/16/2008WEDNESDAYNON
      1/17/2008THURSDAYNON
      1/18/2008FRIDAYNON
      1/19/2008SATURDAYNON
      1/20/2008SUNDAYCITY
      1/21/2008MONDAYCITY
      1/22/2008TUESDAYCITY
      1/23/2008WEDNESDAYCITY
      1/24/2008THURSDAYCITY
      1/25/2008FRIDAYCITY
      1/26/2008SATURDAYCITY
      1/27/2008SUNDAYNON
      1/28/2008MONDAYNON
      1/29/2008TUESDAYNON
      1/30/2008WEDNESDAYNON
      1/31/2008THURSDAYNON