DATE Function Archives

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)

Jul 25, 2022 Excel Formulas

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)

Jul 14, 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. ...

How to Get Historical Data of NSE Stocks in Excel (2 Effective Ways)

Jun 12, 2022 Excel for Finance

If you are trying to collect historical data of NSE stocks in Excel, then you will find this article useful. NSE is the abbreviation for National ...

How to Track Multiple Projects in Excel (Download Free Template)

Jul 26, 2022 Excel Basics

On a regular day, A project manager has to manage multiple projects at once. Tracking those projects could be tedious if they are not organized ...

How to Create Leave Tracker in Excel (Download Free Template)

Jul 26, 2022 Excel Basics

Leave tracker is a widely used task for the human resource department to track every people for their vacation and working days. Almost every ...

Split Date and Time Column in Excel (7 Easy Methods)

May 11, 2022 Excel Formulas

If you have a date and time in the same cell and need to separate them into two different columns, you are in right place! In this article, I will ...

How to Calculate Difference Between Two Dates in Days in Excel

Jun 8, 2022 Excel Formulas

We’ll show you 7 quick methods of how to calculate the difference between two dates in days in Excel. To demonstrate our methods, we’ve picked a ...

How to Separate Date in Excel Using Formula (5 Suitable Ways)

May 11, 2022 Excel Formulas

Separating dates from different parts of the text or time is one of the most common uses of Excel. Also extracting day month and year from part of ...

Formula to Hide Rows in Excel (7 Methods)

May 31, 2022 Excel Formulas

In Excel, while we want to view as many rows or information as possible, at the same time we want to hide some of the unimportant rows. Maybe because ...

How to Calculate Percentage of Month in Excel (4 Ways)

May 30, 2022 Excel Formulas

Assume you have a set of dates in a spreadsheet and want to know what percentage of the year or month has passed or remains based on the given date. ...

How to Generate Random Date and Time in Excel (3 Ways)

May 18, 2022 Excel Formulas

For many demonstration or experimental purposes, you may want to fill up Excel columns with random dates and times. You of course can fill those ...

How to Insert Date in Excel Formula (8 Ways)

May 25, 2022 Excel Basics

Excel can store date values as a different category of its own. Dates starting from 1st January 1990 follows this pattern. You can write dates ...