Compare Event and Date

[ch_riadh]

Hi.

I have an excel with 2 sheets:

1- Sales and Date.

2- Field 1(event)

     Field 2(DateFromCY)

     Field 3(DateToCY)

     Field 4(DateFromLY)

     Field 5(DateToLY)

     Field 6(Event Comparable)

     Field 6(DateFromComp)

     Field 6(DateToComp)

 

I want :

Column 1: example: Compare Sales event 20-1 Current year with Last Year same period.

Column 2: Compare event sales with the event comparable Sales ( Same row ),

                    example: Event 20-11  with  Event comparable 17-34.

Find the attached excel file.

Don't hesitate if you have any question.

Thank you.