How to Create WTD, MTD ,YTD in Excel???

Do activate the Analysis ToolPack add-in in order to utlise the =Weeknum function.

For the WTD, if your first day of the week begins on the Sunday, put 1 at the "return type" of the weeknum function, put 2 if it begins on the Monday.

• to Date formulas.xls