Announcement

Collapse
No announcement yet.

Find Public Holidays by City - Formula $15

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Find Public Holidays by City - Formula $15



    I need a formula to look up if a date exists and calculate how many public holidays there is within that month and the formula sums that number into the corrisponding Persons Month.

    The criteria is: There are 2 sheets to use
    - Sheet1 (this is where the data will be posted, by person > by location > by Month)
    - WA Public Holidays(we have 2 columns that have the specific dates of our public holidays from a colum that is Month)

    Sheet1
    Aug 19 Sep 19 Oct 19 Nov 19 Dec 19 Jan 20
    Fred Fremantle 1 2 2
    Mark Brisbane 3 2
    Paul Fremantle 1 2 2
    WA Public Holidays
    Brisbane Fremantle
    5-Sep-19
    25-Dec-19 25-Dec-19
    26-Dec-19 26-Dec-19
    1-Jan-19 1-Jan-20
    26-Jan-19 26-Jan-20

  • #2
    Hi,
    I can look at this for you.
    Can you confirm that you have pay the 10% to Ozgrid
    - Thanks

    Comment


    • #3
      I can confirm payment to ozgrid

      Comment


      • #4
        Thanks.
        I got your file via your PM and have a solution ready.

        I will send you payment detail via PM

        Comment


        • #5
          Solution and payment details sent via PM

          Comment


          • #6
            Still waiting for payment

            Comment


            • #7


              Funds received.... Thanks!!

              Comment

              Working...
              X