The post demonstrates how to predict the date of the day if we add days to a date in excel.
Let’s see how to add days to a date in excel.
Suppose want to add a specific number of days to a given date and want to know what would be the date on that day.
As we know excel internally treats the data as an integer which helps us keeping track of the dates.
So if we want to add 42 days to a date June 24th 2016, it will add the number 42 to the date and gives the date equivalent to the given date plus 42 days.
As shown below after 42 days of June 24th 2016 the date is August 5th 2016.
So if we want to have a sequence of every alternate days in excel, just keep adding two to the date and drag the formula as shown below.
Hope this helped.
