Calculating Prior day using formula

[alan_grn]

I am trying to calculate the prior day using variables.

What is the best way to do this?

I have a table of dates but they are not consecutive as weekends are excluded. If the user select the date for the Monday I would like a variable to calculate the previous day which would be Friday.

[carvalguil]

try something like

=Max({1<Date={"<$(=Date)"}>}Date)

[geert_gelade]

You can use the firstworkdate() function.

If 28/09/2014 is selected (which is a monday), the result is 25/09/2014 (friday).