By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
if the given date is 06/07/2000(mm/dd/yyyy format)
then this formula calculates the weekend saturday date as 06/10/2000.
if the given date is a saturday, then it is the same as the weekend date.
strtDay := @Weekday(GivenDate);
weekday := @If(strtDay < 7;@Adjust(Givendate;0;0;(7-strtday);0;0;0);Givendate);