Try this:
=WORKDAY(A1-1,1)
for a date of 7/29/33, i'm getting 7/31/33, however 7/29 is a friday, not saturday or sunday. please advise.
7/29/33 is being translated as 1933 not 2033.
7/29/1933 was a Saturday hence the rollover to Monday.
If you want 7/29/2033 you'll need to enter the date as 4 digits.