Find Previous Date upto 5 days

[rammuthiah]

Need logic to find sheet 2 Date given in below sample data

[pradosh_thakur · Accepted solution]

could you be more specific

something like

if([Sheet 1 Date]-[Sheet 2 Date]=5,[Sheet 2 Date],null())   ????

regards

Pradosh

[MK9885]

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

sum({<Sheet1Day=  {$(=(Sheet1Day)-5)}>}(Sheet1Day))

Not sure if the expression is correct but it would give me the values against day selected.