Time and Date
Excel, as a product, always remains under active development from Microsoft. With new releases, new features are brought in whereas old ones are discarded. Due to this there might be changes to the solutions mentioned below depending on the version that you are using.
In many cases you will get business problems where you need to add or subtract month/year from a given date. Can you show how to do that in excel?
Answer
This can be done easily using the
DATE
function. The below formula will deduct a month, similarly one can change the year and date. =DATE(YEAR(A3),MONTH(A3)-1,DAY(A3))
Last modified 9mo ago