DATE Function Archives

Advanced Use of COUNTIFS Function in Excel (9 Examples)

Nov 17, 2022 Excel Formulas

The COUNTIFS function is a built-in-in function of Excel. It is more advanced than the COUNTIF function. The COUNTIF function satisfies only one ...

[Fixed] COUNTIF Function with Wildcard Not Working in Excel

Nov 9, 2022 Excel Formulas

The COUNTIF function is used extensively to count values based on criteria. Using wildcards in the criteria makes the formula more dynamic. ...

How to Add and Subtract Dates in Excel (6 Suitable Ways)

Oct 13, 2022 Excel Formulas

While continuing to work with a dataset, sometimes users need to know how to add or subtract dates in Excel. You can simply Add and Subtract Dates in ...

How to Create a Schedule in Excel That Updates Automatically

Oct 3, 2022 Excel Formulas

Creating a schedule is a part and parcel of many of our lives. Creating the schedule automatically will be immensely helpful for many people. If you ...

How to Create a Monthly Schedule in Excel (3 Simple Ways)

Sep 22, 2022 Excel Formulas

Looking for ways to know how to create a monthly schedule in Excel? We can make our day-to-day life easier by making a schedule for every work. Here, ...

Excel COUNTIF Function with Multiple Criteria & Date Range

Sep 28, 2022 Excel Formulas

If you are looking for ways to use the COUNTIF function with multiple criteria date range in Excel, then this article will be helpful for you. ...

How to Create a Monthly Calendar in Excel (3 Effective Ways)

Oct 17, 2022 Advanced Excel

Excel is a great tool to automate several calculations and templates. You can create many types of monthly calendars through Excel. If you are ...

Convert Epoch Time to Date in Excel (2 Easy Methods)

Sep 12, 2022 Excel Formulas

Epoch time is the beginning point (date and time) from which computers measure their system time. For example, the epoch time in UNIX and POSIX-based ...

Formula for Weekly Dates in Excel (5 Examples)

Sep 8, 2022 Excel Formulas

The main focus of this article is to explain formula for weekly Dates in Excel. If you are looking for formulas for weekly dates, then this article ...

Conditional Formatting for Dates Older Than Certain Date in Excel

Sep 4, 2022 Excel Formulas

In our Excel spreadsheet, we use dates to track the data according to our desire. Sometimes, we require conditional formatting to highlight those ...

How to Create a Bullet Journal in Excel (with Detailed Steps)

Jul 31, 2022 Advanced Excel

This article illustrates how to create a bullet journal in excel. A bullet journal is a system of organizing to-do lists, daily tasks, monthly goals, ...

Attendance and Overtime Calculation Sheet in Excel

Aug 8, 2022 Excel Formulas

You are in the right place if you have questions about how to keep records of attendance and calculate overtime hours in Excel based on employees' ...

How to Convert 8 Digit Number to Date in Excel (3 Effective Ways)

Sep 11, 2022 Excel Formulas 3

Sometimes, you have a column of data that contains dates in the form of numbers, and you need to convert those numbers into dates. If you have a ...

Excel Gantt Chart with Conditional Formatting (2 Examples)

Sep 29, 2022 Excel Charts

Gantt Chart is a widely used chart in the managemental branch of any organization. It displays the activities of that institution against the time ...

Student Loan Payoff Calculator with Amortization Table in Excel

Jul 11, 2022 Excel Formulas

Most of the students had to deal with the loan. The complex calculation of loan Repayment amount and how long it will take is difficult for anybody. ...