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

General Formula:

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

=CEILING(date+1,14)-1

Syntax Explanations:

CEILING – In Excel, the CEILING function 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.

Select any cell and type the above-given formula.

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

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!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **