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.

Time Diff

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 updated