Compare Event and Date

ch_riadh — Sat, 16 Nov 2024 04:19:52 GMT

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.

topic Compare Event and Date in App Development