Here are a few Excel DATE formula examples. With the target date in B3 and the number of days in B4 the formula is as simple as adding up two cells. The subtraction formula in cell A6 makes use of these numbers to find the number of days between the two dates 43405 - 42292 1113.
The DATE function is also useful when providing dates as inputs for other functions such as SUMIFS or COUNTIFS since you can easily assemble a date using year month and day values that come from a cell reference or formula result.
Type a formula like the above example. Learn how to format a cell as a number or date. YEARFRAC DATE G211 A21. In cell L2 create a formula to calculate the fraction of the year that has passed as of the date in A2.