The DATE function returns the sequential serial number that represents a particular date. Click here to Read Full Tutorial
=DATE(YEAR,MONTH,DAY)
=EOMONTH(C3, 0)
.Click on any cell below to start practicing EDate Function. Check Instruction how to use the EDate Function.
=EDATE(C3, 1)
.Click on any cell below to start practicing Today & Now Function. Check Instruction how to use the Today & Now Function.
Click on any cell below to start practicing Weekday Function. Check Instruction how to use the Weekday Function.
=TEXT(WEEKDAY(A2, 11), "DDDD")
.Click on any cell below to start practicing Weeknum Function. Check Instruction how to use the Weeknum Function.
Click on any cell below to start practicing Workday Function. Check Instruction how to use the Workday Function.
F3
).=WORKDAY
and open the parentheses.B4
).F1
).B5:B8
).Click on any cell below to start practicing Workday.INTL Function. Check Instruction how to use the Workday.INTL Function.
F3
).=WORKDAY
and open the parentheses.B4
).F1
).B5:B8
).Add new line in Excel cell lets you type on multiple lines within the same cell. Instead of having all the text in one long line, you can split it up to make it easier…
In Excel, a line break lets you finish one line of text and begin another within the same cell. It helps create separate lines of information without needing to move to a different cell.
Create Dynamic Data Validation List When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation” technique where I want a smart data validation to avoid all…
How to Insert Symbol in Excel? I came across many queries regarding inserting special symbols in Excel. Here we are guiding how you may do this quickly in excel. Follow these steps and you may…
What is Excel Cell Reference? Excel Cell references are the names of cells. A cell reference has a letter and a number. The letter comes from the column (A, B, C…) and the number comes…
This tutorial explains what an Excel name is and shows you how to define a name for a cell, range, constant, or formula. You’ll also learn how to edit, filter, and delete defined names in Excel.
Excel names are a bit of a paradox: they’re one of the most useful features, but many people find them unnecessary or too technical. That’s because few users truly understand what Excel names can do. This tutorial will not only teach you how to create a named range in Excel but also show you how this feature can make your formulas easier to write, read, and reuse.