So far, everything has been very straightforward. But when we start talking about the return_type argument, it can get a bit confusing.
When we ran the function the first time, we left the argument blank. Which means it defaults to counting weeks that begin on Sunday.
But including an argument in that field can change the answer you get.
Click into cell C2 and type the following formula:
Hit Enter, and you’ll get a different answer this time.
Because of that 2 in the return_type spot.
You can put a variety of numbers here. And they affect what you’ll get in return.
Here’s what you need to know:
- 1 (or left blank): week begins on Sunday.
- 2: week begins on Monday.
- 11: week begins on Monday.
- 12: week begins on Tuesday.
- 13: week begins on Wednesday.
- 14: week begins on Thursday.
- 15: week begins on Friday.
- 16: week begins on Saturday.
- 17: week begins on Sunday.
- 21: week begins on Monday (European system; the first week containing a Thursday is counted as the first week in the year).
If you can’t remember this entire list (and who can?), start typing the formula and Excel will pop up a tooltip that gives you the available options: