Autofill Weekdays in Google Sheets

Question

I know you can find the number of days between workdays and other return values, but i am having trouble finding a way to use the Workday or Weekday formula and have it return the next date that is a workday. I would also like to use the Autofill feature to be able to fill it down Column A with the start date Hard Coded in cell A1. (excluding weekends (Saturday, Sunday)) Thank you for the help!

Answer 1

I hope this answer is helpful to others who visit here to find answer.

Here's answer for you: Autofill weekdays only ....

You can autofill weekdays excluding weekend(saturday, sunday) like below

A2: first date

A3: =A2+IF(WEEKDAY(A2)>5,3,1)

and fill A3 down.

Note: not =6 just >5