Excel IF function combining with TODAY function. Formula DATEyearmonthday The DATE function includes the following arguments. In the screenshot below you can clearly see how each works and what the corresponding output is.
The value of the year argument can include one to four digits.
The MONTH and DAY functions only return the original values from cell A2 but the DATE function requires them. Generic formula DATELEFTtext4MIDtext52RIGHTtext2. Series of dates by month In the example B6 is the hard-coded start date and the formula in B7 is. Date Range TEXT A2mmm d IF B2 - TEXT B2mmm d So we can see that the above formula creates a full date range using both the dates when both are present.