# WEEK/WEEK\_OF\_YEAR

{% hint style="success" %}
Use familiar syntax such as **`WEEK_OF_YEAR`** to determine the week number of the year for a given date or datetime.
{% endhint %}

| **Description** | The **`WEEK()`** function calculates and returns the week number of the year for a given date or datetime. This is useful for time-based analysis, scheduling, or organizing data by weeks. |
| --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Syntax**      | WEEK(**`date`**)                                                                                                                                                                            |

1. **`date`**: The date or datetime for which you want to determine the week number.

## Example

### Table

| Event   | Event Date |
| ------- | ---------- |
| Event A | 2023-09-10 |
| Event B | 2023-08-25 |
| Event C | 2023-01-15 |
| Event D | 2023-12-31 |

### Function

```
WEEK(`Event Date`)
```

### Results

| WEEK (integer) |
| -------------- |
| 36             |
| 34             |
| 2              |
| 52             |
