Date formula in microsoft excel

For more formula examples demonstrating the use of the TODAY function in Excel, please check out the following tutorials:. NOW function returns the current date and time. If you wish to display today's date and current time in your worksheet, simply put the following formula in a cell:. To make the NOW function automatically update every second or so, a VBA macro is needed a few examples are available here.

In the pure sense, the TEXT function cannot be classified as one of Excel date functions because it can convert any numeric value, not only dates, to a text string. It can be a cell reference, a date entered by using the DATE function , or returned by other formulas.

Most often you would utilize it in conjunction with other functions as demonstrated in the following examples:. The Excel YEAR function is very straightforward and you will hardly run into any difficulties when using it in your date calculations:.

The WEEKDAY function can help you determine which dates in your Excel sheet are working days and which ones are weekend days, and also sort, filter or highlight workdays and weekends:. Which time interval to use for calculating the date difference depends on the letter you enter in the last argument:. HOUR function. MONTH function. INTL function. Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.

NOW function. TIME function. TODAY function. Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days.

YEAR function. Learn more about the differences. Excel functions by category. Excel functions alphabetical. Need more help? Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Excel functions alphabetical.

Excel functions by category. How to avoid broken formulas. Formulas and functions. More functions. Need more help? Expand your skills. Get new features first. Was this information helpful?