Excel formula to add a range of days to a starting date

[TizianaB]

Hi,

I need to create a formula (using Excel 2010) to add a range of days to a starting date.

To clarify, I have a starting date (eg. the date of a blood test, done on 01/01/2020) and I need to know when to do a follow up blood test control - this has to be done as FollowUp1: between 3 and 10 days after the first test; FollowUp2: between 11 and 20 days after the first test, and so on. 

So I would need to create a formula that tells me the range of dates for the follow up tests (eg. FollowUp1: 03/01-10/01/2020). 

Any idea on how to create such a formula, if possible? 

Thank you

Tiziana

[#2 · Accepted solution]

@TizianaB Please see attached file for several ways how to approach this. Personally, I favour keeping the dates intact as apposed to creating a text string of the date range for the follow-up test.

[#3]

Thank you very much Riny! will have a look at this right now

[#4]

That is amazing, thank you so much!!

[#5]

@TizianaB Glad I could help!