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