SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1666985%22%20slang%3D%22en-US%22%3EExcel%20formula%20to%20add%20a%20range%20of%20days%20to%20a%20starting%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1666985%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20formula%20(using%20Excel%202010)%20to%20add%20a%20range%20of%20days%20to%20a%20starting%20date.%3C%2FP%3E%3CP%3ETo%20clarify%2C%20I%20have%20a%20starting%20date%20(eg.%20the%20date%20of%20a%20blood%20test%2C%20done%20on%2001%2F01%2F2020)%20and%20I%20need%20to%20know%20when%20to%20do%20a%20follow%20up%20blood%20test%20control%20-%20this%20has%20to%20be%20done%20as%20FollowUp1%3A%20between%203%20and%2010%20days%20after%20the%20first%20test%3B%20FollowUp2%3A%20between%2011%20and%2020%20days%20after%20the%20first%20test%2C%20and%20so%20on.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20would%20need%20to%20create%20a%20formula%20that%20tells%20me%20the%20range%20of%20dates%20for%20the%20follow%20up%20tests%20(eg.%20FollowUp1%3A%2003%2F01-10%2F01%2F2020).%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20on%20how%20to%20create%20such%20a%20formula%2C%20if%20possible%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3ETiziana%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1666985%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1667008%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20to%20add%20a%20range%20of%20days%20to%20a%20starting%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1667008%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F793670%22%20target%3D%22_blank%22%3E%40TizianaB%3C%2FA%3E%26nbsp%3BPlease%20see%20attached%20file%20for%20several%20ways%20how%20to%20approach%20this.%20Personally%2C%20I%20favour%20keeping%20the%20dates%20intact%20as%20apposed%20to%20creating%20a%20text%20string%20of%20the%20date%20range%20for%20the%20follow-up%20test.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

4 Replies
best response confirmed by TizianaB (New Contributor)
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.

Thank you very much Riny! will have a look at this right now
That is amazing, thank you so much!!

@TizianaB Glad I could help!