Explanation
In this example, the goal is to add days to a date.
About Excel dates
In Excel,dates are stored as serial numbersthat begin with 1.
In the worksheet shown, we are not hardcoding days into the formula.
Instead, we are picking up the days entered in column C with a cell reference.
Mon, Tue, etc.)
along with the date.
This approach is more flexible since you’re able to enter negative or positive days.
In these scenarios, you might add days with theWORKDAY functionor its more flexible siblingWORKDAY.INTL.
Instead, you should use a different approach based on theEDATE function.
TheEOMONTH functionworks in a similar way to EDATE but will always return a date at theend of a month.
The TODAY function takes no arguments.
you could format the value returned by TODAY with a datenumber format.
