Time and Date
Time and Date#
Warning
This page is a work in progress
Note
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.
Problem: Add Month or Year
In may 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?
Solution:
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))