Table of Contents
INTRODUCTION
DATES and TIME , if you are new to Excel and you have already tried using those format, I am pretty sure that you must have felt panicky at some sort of time.
It is quite obvious because when we don’t know the exact working of any system or process, we try to use it just by hit and trial method. It works sometimes and sometimes not.
Here we are talking about Dates and Time in Excel. These are the tricky formats which we need frequently in our reports or charts.
Many times, we need to do operations on them. We need to put them in the conditions to trigger some event which makes it very important for us to learn the exact procedures to perform a task concerned with the dates and time.
In this article we would learn different tricks and methods to handle and manipulate Dates and Time formats so that they don’t mess up with our reports.
One of the trick is to find the date 30/60/90/120 or n [any custom number] days ago. [For example suppose it is 31st July today. What was the date 5 days ago etc. ]
In this article we would learnt about.
FIND THE DATE N [30/60/90/120] DAYS AGO
While creating any report , we might come across a situation where we need to find a date fixed number of days ago from a given date.
CONCEPT:
The concept is quite simple.
As we know that
DATE IS JUST A NUMBER. IF WE SUBTRACT THE NUMBER OF DAYS SIMPLY FROM THE DATE, IT’LL RETURN THE DATE N DAYS AGO.
We’ll use the same concept to find out the date n days ago. [ n is the number of days]
STEPS TO FIND THE DATE N DAYS AGO
- Choose the cell where the date after a particular number of days is need to be found.
- Enter the following formula “=cell address of date – number of days after which date is needed”
- As we know date is just a number, we just need to subtract the number of days and the result will be the date after that many days.
EXPLANATION:
We have the date given in the CELL H25. The given date is 29-06-2020.We need to find the date 3 days ago, which is given by the formula in which we subtract 3 from the date in the H25.The result is 26-062020 which is correct.