The second element of our SUMPRODUCT formula poses a similar TRUE-FALSE question. It asks Excel to look at the date, and determine its month. The MONTH() formula will return the number corresponding ...

You should have experience with Excel before trying to use formulas to calculate what day of the week the 15th of a given month is, and you have several options to do this. Cell Formatting ...

In the same example, if the product expires 3 months later, at the end of that month, you can apply the following formula in cell B2 to calculate the expiry date: =EOMONTH(A2, 3) ...

Learning Excel and its functions and formulas can be tricky, but here are the basics. ... You will pay just $6.99 per month for the full Microsoft 365 subscription, though, ...