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
).Watch: How to use TODAY & NOW Function in Excel? What is TODAY Function? The TODAY function in Excel returns the current date in a serial number format. Click here to Read full Tutorial What is…
Video: How to Hide Worksheet in Excel? Hide Sheet in Excel When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any…
Lock Cells to avoid editing, Hide Formulas Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and…
Watch: How to use EOMONTH & EDATE Function in Excel? What is EOMONTH Function? The EOMONTH function in Excel returns the last day of a month based on a given date and a specified number of…
Undo in excel very useful If you’re new to Excel or even if you’ve been using it for a while, you’ve probably made a mistake on a spreadsheet. Mistakes happen a lot, especially when working…
Print Row Header on Each Page in Excel means that when you print your worksheet, the selected row (often the top row with column headers) will repeat at the top of every printed page. This ensures…