Good day,

I'm looking for a function similar to weeknum() in MS Excel with which I can get week number from a date. I check on Date/Time Functions help page but I didn't see it.

Thank you.

Staff Response:

While it's not built-in, you can calculate it as follows

Trunc(DaysBetween("1/1/" + Year(Today()), Today()) div 7)

...just replace Today() with the field containing the date if you need to.