- Turn on or off week numbers in month view and the Date Navigator for . . .
To view the week numbers, open your calendar, and on the ribbon select Month On the left margin of the calendar, you'll see numerals representing the week numbers Week numbers can appear on the calendar month view and in the Folder Pane By default, week numbers are turned off
- Add or subtract dates - Microsoft Support
Suppose you want to adjust a project's schedule date by adding two weeks to see what the new completion date will be, or you want to determine how long a single activity will take to complete in a list of project tasks
- DateDiff Function - Microsoft Support
When interval is Weekday ("w"), DateDiff returns the number of weeks between the two dates If date1 falls on a Monday, DateDiff counts the number of Mondays until date2
- Show dates as days of the week - Microsoft Support
Let's say you want to see the date displayed for a date value in a cell as "Monday" instead of the actual date of "October 3, 2005 " There are several ways to show dates as days of the week Note: The screenshot in this article was taken in Excel 2016
- Display or change dates on a category axis - Microsoft Support
Date axes are available on stock charts, line charts, column charts, bar charts, and area charts Date axes are not available on PivotChart reports In a chart, you can change a category axis to a date axis, and you can also change the base units displayed in the date axis
|