Very often, you will have business problems where you have to add or subtract month from a given date. One scenario is calculation for EMI Date.
Say, you have a date of 10/22/14 (MM/DD/YY) in A1 and you want to add number of months which is contained in Cell B1.
The formula in this case would be
=EDATE(A1,B1)
[Secondary formula =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) ]
Now, you want to subtract month which is contained in Cell B1.
=EDATE(A1,-B1)
[Secondary formula =DATE(YEAR(A1),MONTH(A1)-B1,DAY(A1)) ]
Hi,
Your brand deserves to stand out, and we’re here to help.
At Global Wide PR, we specialize in connecting businesses with top media platforms to increase visibility and credibility. As a gesture to get started, we’re offering a free article on Digital Journal—a great way to showcase your business to a wider audience.
For those looking to maximize exposure, we can also feature your brand on affiliates of FOX, NBC, CBS, ABC, and 300+ other sites for just $297. These placements can help you build trust and attract new customers.
To take advantage of this opportunity, click the link below to sign up on our site, and we’ll get back to you ASAP:
https://bit.ly/globalwidpr
Looking forward to helping your brand shine!
Best regards,
Claudine
Global Wide PR
We value your preferences and understand that you might prefer not to receive our updates. To stop receiving communications from us, please submit the unsubscribe form with your website address: bit. ly/unsubscribemeurl