Need logic to find sheet 2 Date given in below sample data
could you be more specific
if([Sheet 1 Date]-[Sheet 2 Date]=5,[Sheet 2 Date],null()) ????
Day-5 would give you 5 days back.
In script use
day([Sheet 1 Date]) as Sheet1Day,
day([Sheet 2 Date]) as Sheet2Day,
In expression use
Not sure if the expression is correct but it would give me the values against day selected.
Retrieving data ...