DATE Function

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

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

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)

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)

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

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)

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)

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)

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)

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

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)

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)

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)

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)

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)

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 ...

ExcelDemy
Logo