Sep 14 2020 08:25 PM - edited Sep 14 2020 08:29 PM
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
Sep 14 2020 08:48 PM
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.
Sep 14 2020 08:54 PM
Sep 14 2020 08:56 PM
Sep 14 2020 09:01 PM
@TizianaB Glad I could help!
Sep 14 2020 08:48 PM
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.