What is the day and hour for EOWEEK

I was wondering when does EOWEEK end? I was thinking it ended at 12AM Saturday? For example its 11:59PM Friday and then the clock strikes 12AM Saturday and it’s now the EOWEEK. Is that how it works?

Good question! I am not certain but you can test it. Give the EOWEEK(0 function a hard coded Saturday date. Does it return that same Saturday or the next Saturday?

If the same, then you know it gives a different result once the date flips to Sunday. Otherwise, it’s when it flips from Friday to Saturday.

The article doesn’t specify this but here it is in case you want other info:

2 Likes