Subtract 2 Cells In Excel Vba

The start date and the number of months that you want to add or subtract. To subtract months enter a negative number as the second argument.

Excel 2016 Formulas 9781423231899 Excel Tutorials Excel Formula Excel

Add or subtract months from a date with the EDATE function.

Subtract 2 cells in excel vba. The EDATE function requires two arguments. If B2s value is 1 to 5 then multiply E2 by 77 If B2s value is 6 to 10 then multiply E2 by 735 If B2s value is 11 to 19 then multiply E2 by 7. You can use the EDATE function to quickly add or subtract months from a date.

Im very new to the Excel world and Im trying to figure out how to set up the proper formula for an Ifthen cell. What Im trying for is.

19 Tips Of The Day With Evba Info And Etipfree Com Ebook Vba Excel