MacMost Q&A Forum • View All Forum QuestionsAsk a Question

Can You Calculate Future Dates Based On a Start Date?

Is there a formula to calculate dates? For example, if you enter a start date, can you then calculate out what date it is 3 days after the start date, 10 days, 20 days?

Setting up a tracking system for honeybee queen rearing. Different actions need to be taken on different days after the eggs first appear. Hoping to autofill with dates instead of counting days from the start date.

Comments: One Response to “Can You Calculate Future Dates Based On a Start Date?”

    2 years ago

    All you need to do is to add. For instance, if cell B2 is a date, like 4/1/2021, then you could do =B2+3d to get 3 days into the future. Durations use d for days, w for weeks.

Comments Closed.