DATEMINUTE_ADD() : add minutes to a date and time

In a formula column, the DATEMINUTE_ADD() function displays a date and time obtained by adding a number of minutes to a date and time column. The result is a date and time.

The key point: the source column must include time. If the Time option is not enabled on the date column, DATEMINUTE_ADD() has no time to shift.

Syntax

DATEMINUTE_ADD(date_column, number_of_minutes)

Parameters

# Parameter Description

1 date_column The date and time column to add minutes to.

2 number_of_minutes The whole number of minutes to add. Positive to move forward, negative to move back.

Examples

Shift a date and time by 30 minutes

The column returns the date and time shifted by 30 minutes.

DATEMINUTE_ADD($Date, 30)

DATEMINUTE_ADD shifting a date and time by 30 minutes

Your formula returns 0 or stays empty

The source column does not include time

Enable the Time option on the source date column so DATEMINUTE_ADD() has an hour to shift.

The column output format is not Date

In the Options tab, set the output format to Date and enable time. For details, see Output format options in the Formula column article.

Go further

DATEHOUR_ADD

For an offset expressed in hours rather than minutes.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.