Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try something like
=Max({1<Date={"<$(=Date)"}>}Date)
You can use the firstworkdate() function.
If 28/09/2014 is selected (which is a monday), the result is 25/09/2014 (friday).