Calculating Age Criteria

[fareedm]

Hello,

Can someone please help with on how to calculate Age criteria for a given column. Below is the data set.

Entry Date = 22/11/2021

Report Date = Every Friday's date ( When performed on Monday or Tuesday )

Age Calculation to be = Entry Date - ( Last Friday Date ) - 3 or 4 ( When performed on Monday's or Tuesdays) 

Need the formulae.

Thanks

[atcodedog05]

Hi @fareedm 

Here is how you can do it.

Workflow:

Hope this helps : )