Excel will automatically jump to sort the dates. If you want to leave the hospital every Saturday and Sunday or every Monday to Friday

If it's just Saturday and Sunday.

= "Week"&; IF(MOD(ROW(A 1), 2), "six", "day")

If you want to use date arrangement, first determine a start date. Take April 16 as an example.

= text (40649+(row (a1)-1) * 7+mod (row (a2), 2), "week AAA")

It is scheduled for April 16.

= text(40649+(row(a 1)- 1)* 7+mod(row(a2),2)," m month d ")

Copy formula