---
title: WEEKDAY
description: Learn how to use the WEEKDAY function to return the day of the week as text, ideal for date-related data analysis and reporting.
---
import { Aside,Steps } from '@astrojs/starlight/components';

# WEEKDAY

The WEEKDAY function in Infoveave returns the day of the week as text for a given date.

## Applicable to

Calculated Columns

## Return Value

The function returns the day of the week as text (e.g., "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday").

## Remark

* The WEEKDAY function helps analyze date-related data by breaking down days of the week. This is crucial for time-based data analysis and reporting.
* The WEEKDAY function does not consider nulls or blanks.

## Syntax

```
WEEKDAY(<expression>)
```


<Aside type="tip">
You can use the system-defined date functions `@StartDate` and `@EndDate`.
</Aside>

## WEEKDAY in Calculated Columns

 Write the WEEKDAY function. For instance

```
WEEKDAY(<expression>)
```
<Steps>
1. Replace `<expression>` with the start period. You can also use `@StartDate` and `@EndDate` functions.
2. To learn how to add calculated columns in Infoveave, visit the [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/) section.
</Steps>

**Example**

Suppose you want to create a column that returns the weekday based on the column `SALES DATE`. You can use the WEEKDAY function as follows

```
WEEKDAY(DATEVALUE(VALUE([Sales Date])))
```


<Aside type="tip">
When using the `DATE` function within `WEEKDAY`, you don't need to include the `DATEVALUE` function in your formula.  For example

```
WEEKDAY((DATE(2024, 05, 01))) 
```

will return Wednesday.
</Aside>