# How to bucket the Date data biweekly

**URL:** <https://community.exploratory.io/t/how-to-bucket-the-date-data-biweekly/2005>\
**Category:** Uncategorized\
**Created:** [March 4, 2021, 12:25am UTC](https://community.exploratory.io/t/how-to-bucket-the-date-data-biweekly/2005 "2021-03-04T00:25:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![user1](https://community.exploratory.io/user_avatar/community.exploratory.io/user1/32/11_2.png) [@user1](https://community.exploratory.io/u/user1)\
**Post date:** [March 4, 2021, 12:25am UTC](https://community.exploratory.io/t/how-to-bucket-the-date-data-biweekly/2005/1 "2021-03-04T00:25:32Z")

</div>

Suppose you have Sales data and you want to bucket the Order Date biweekly. Here is how.

 ![image](https://community.exploratory.io/uploads/default/original/2X/8/8d9687884ffecd1e1b117221205d6fdd3fd9e22c.png)

From the column header menu of “Order Date” column, choose “Create Calculation”.

 ![image](https://community.exploratory.io/uploads/default/original/2X/a/a7f60cb0c59550287dd7c926530d079c4a76ad78.png)

In the “Create Calcuation” dialog,

- Choose “Overwrite Existing Column” and select “Date” column.
- Type in the following expression in Calculation Editor.

```auto
14 * (as.numeric(Date - min(Date)) %/% 14) + min(Date)

```

 ![image](https://community.exploratory.io/uploads/default/original/2X/4/41b73ded127a3323325ac5fa6b824346dca0a475.png)

You get the Date data bucketed biweekly starting from the oldest date in the column.

 ![image](https://community.exploratory.io/uploads/default/original/2X/6/6c19a771860fdb40d90254cb41195fbc39073b56.png)