Learn Microsoft Excel Online FreeThis post will guide you how to count dates in a give year or month or day with a formula in Excel. How do I count cells based on year, month or day in Excel. How to countif by a specified date (Year or month) in a range of cells in Excel. Count Dates in… read more »
This post will guide you how to get the first Monday of a given year or date in excel. How do I calculate the first Monday of a specific year in excel. How to determine the first Monday in a given year date with a formula in excel. How to find and get the date… read more »
This post will guide you how to allow a user to enter only dates of current year in excel. How do I set the limitation to allow a user to enter the date of current year in a cell in excel. And this post will talk that how to use data validation with a custom… read more »
This post will guide you how to use Excel MONTH function with syntax and examples in Microsoft excel. Description The Excel MONTH function returns the month of a date represented by a serial number. And the month is an integer number from 1 to 12. And you can use the MONTH function to get a… read more »
This post will guide you how to use Excel TODAY function with syntax and examples in Microsoft excel. Description The Excel TODAY function returns the serial number of the current date. So you can get the current system date from the TODAY function. The serial number is the date-time code used by Excel for date… read more »
This post will guide you how to use Excel YEAR function with syntax and examples in Microsoft excel. Description The Excel YEAR function returns a four-digit year from a given date value, the year is returned as an integer ranging from 1900 to 9999. So you can use the YEAR function to get the year… read more »
This post will guide you how to add or subtract a given number of days to a date in excel. How to add or subtract weeks to a date using excel formula. How to add or subtract a certain number of months to a date using excel formula. How to add or subtracts a given… read more »
