Forum Discussion
wirebear
Oct 25, 2019Copper Contributor
Trying to get weekend dates that are typed in to round to nearest workday
Trying to get Saturday dates to round to Friday and Sunday Dates to round to Monday. I have formulas to do one or the other but can't figure out how to place both formulas for single cell. =IF(...
Twifoo
Nov 10, 2019Silver Contributor
My alternative version is:
=A5+
(WEEKDAY(A5)=1)-
(WEEKDAY(A5)=7)
=A5+
(WEEKDAY(A5)=1)-
(WEEKDAY(A5)=7)