(相关资料图)

1、今天日期=TODAY()今天是几周=WEEKNUM(TODAY())今天是星期几=TEXT(TODAY(),"aaaa")=WEEKDAY(TODAY()) 第二周 Excel 2007一周按周日开始计算:=WEEKNUM(TODAY())=WEEKNUM(TODAY(),1)一周按周一开始计算:=WEEKNUM(TODAY(),2)。

本文就为大家分享到这里，希望小伙伴们会喜欢。