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.
—–
Khona

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

    5 months 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.

Leave a New Comment Related to "Can You Calculate Future Dates Based On a Start Date?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)