excel中的日历功能 [英] Calendar functions in excel
问题描述
我有一个电子表格,我用来管理团队的rota,所以每月一张。
使用公式作为表格的标题来自动计算一年中的月/日
= TEXT(WEEKDAY(DATE(CalendarYear,1,1),1)," aaa")
我将标题显示为Sun,Mon等,具体取决于年份。如下。
员工姓名周一周二周三
1
2
3
4
有没有办法将文本转换为也用数字显示日期?EG:01 Sun 02 Mon等
谢谢,
谢丽尔。
您好
您会接受一个宏,只需按一下按钮或从宏菜单中选择,您的布局就像下面的屏幕截图一样。
I have a spreadsheet, that i am using to manage the rota for my team, so one sheet per month. Using the formula as the heading to the table to auto calculate the month / day of the year =TEXT(WEEKDAY(DATE(CalendarYear,1,1),1),"aaa") I get the heading displayed as Sun, Mon etc depending on the year. As Below. Employee Name Sun Mon Tues Wed 1 2 3 4 5 Is there a way to convert the text to also show the day in numeric as well?
EG: 01 Sun 02 Mon etc
Thank you,
Cheryl.
Hi
Would you accept a macro, just a push of a button or from the macro menu and your layout would look like the screen shot below.
这篇关于excel中的日历功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!