PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
While creating any report , we might come across a situation where we need to find a date after a fixed number of days from a given date.
DATES ARE ONLY THE NUMBERS FORMATTED AS DATES. IF WE ADD ANY NUMBER TO THE DATES, IT’LL SIMPLY GIVE THE DATE AFTER THAT PARTICULAR NUMBER OF DAYS.
We have a date put in the cell H15.
The date is 2nd July 2020.
We need to find the date after three days from 2nd july.
We have used the formula in which we simply add 3 in the given date.
The result is 5th july 2020 which is as expected.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE