Skip to article frontmatterSkip to article content
Site not loading correctly?

This may be due to an incorrect BASE_URL configuration. See the MyST Documentation for reference.

Time and Date

Time and Date

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))

Excel
Data Manipulation
Tensorflow
Basics