excel怎样批量设置3天3天日期

excel怎样批量设置3天3天日期

首页维修大全综合更新时间:2023-06-27 15:29:28

excel怎样批量设置3天3天日期

先把ab列设置为常规a3单元格输入=TEXT(DATE(,2,ROW(A1)),"m.d")下拉b3单元格=TEXT(WEEKDAY(SUBSTITUTE(A1,".","-"),1),"aaaa")下拉ok

大家还看了
也许喜欢
更多栏目

© 2021 3dmxku.com,All Rights Reserved.