Which time interval to use for calculating the date difference depends on the letter you enter in the last argument: - returns the number of complete years between the dates in A2 and B2.These are just the basic applications of the DATEDIF function and it is capable of much more, as demonstrated in the following examples: The following tutorial explains all the specificities on the Excel WEEKNUM function: WEEKNUM function - calculating week number in Excel.A few simple DATEVALUE formula examples follow below: 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.With the TEXT(value, format_text) function, you can change the dates to text strings in a variety of formats, as demonstrated in the following screenshot.
As well as TODAY, Excel NOW is a volatile function that refreshes the returned value every time the worksheet is recalculated.
Alternatively you can skip directly to one of the formula examples: function returns a date N workdays before or after the start date.
It automatically excludes weekend days from calculations as well as any holidays that you specify.
When it comes to working with dates in Excel, DATE is the most essential function to understand.
The point is that other Excel date functions not always can recognize dates entered in the text format.