Excel Formulas to Find the Next biweekly payday with From Date!!
Tags: excelformula, excelformulas
Published: 2021-05-26 09:21:09

---
title: Excel Formulas to Find the Next biweekly payday with From Date!!
published: true
date: 2021-05-25 17:03:11 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-the-next-biweekly-payday-with-from-date/
---

Assume that you have a biweekly schedule, with paydays on Friday. Now you want to find out the **Next biweekly payday from the given date in Excel**. How could you find them quickly? Today I introduce you to some formulas to solve this problem. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Next biweekly payday](https://geekexcel.com/wp-content/uploads/2021/05/Next-biweekly-payday.png)](https://geekexcel.com/excel-formulas-to-find-the-next-biweekly-payday-with-from-date/next-biweekly-payday/#main)<figcaption id="caption-attachment-45603">Next biweekly payday</figcaption>

## General Formula:

- If you want to find out the next biweekly payday, you can use the below formula.

**=[CEILING](https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/)(date+1,14)-1**

## Syntax Explanations:

- **CEILING** – In Excel, the [**CEILING function**](https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/) will help to round the given number to the nearest specified multiple.
- **Date** – It specifies the input dates from your worksheet.
- **Plus operator (+)** – This symbol is used to add the values.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- Here we will enter the input dates in **Column B**.
- Now we are going to calculate the next payday.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-36.png)<figcaption id="caption-attachment-45602">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-85.png)<figcaption id="caption-attachment-45601">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-79.png)<figcaption id="caption-attachment-45600">Result</figcaption>

## Wind-Up:

So yeah guys, this is how we can find out the **next biweekly payday from the given date in Excel**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to List Holidays between Two Dates ~ Easy Tips!!](https://geekexcel.com/excel-formulas-to-list-holidays-between-two-dates/)**
- **[{Tricks} Excel Formulas to Combine Text And Date Into Same Cell!!](https://geekexcel.com/excel-formulas-to-combine-text-and-date/)**
- **[Excel Formulas to Find the Last Updated Date Stamp ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-find-the-last-updated-date-stamp-quick-tricks/)**
- **[Excel Shortcut: Enter and Move Right in MS Excel 365!!!](https://geekexcel.com/simple-shortcut-to-enter-and-move-right-in-ms-excel-365/)**