I had an account on here, but not sure what happened to it so here's to a new one!
My issue is as follows:
I need to create a formula, process, or otherwise that allows me to take two columns of dates (say G1:G100 and H1:H100) and take whichever is smaller of the two (easy enough right?? =if(G1<H1,G1,H1))
HOWEVER - The dates in the resulting column (I1:I100) need to be a certain amount of time apart. Each row must be at least 25 days before the number 3 rows down.
I have a schedule of when the items expire, and am trying to schedule replacements to be done either before or on the expiration date. We have 3 spare sets (resulting in going down 3 rows) and it takes 25 days to replace each.
Thanks in advance for any and all help given!!!!
My issue is as follows:
I need to create a formula, process, or otherwise that allows me to take two columns of dates (say G1:G100 and H1:H100) and take whichever is smaller of the two (easy enough right?? =if(G1<H1,G1,H1))
HOWEVER - The dates in the resulting column (I1:I100) need to be a certain amount of time apart. Each row must be at least 25 days before the number 3 rows down.
I have a schedule of when the items expire, and am trying to schedule replacements to be done either before or on the expiration date. We have 3 spare sets (resulting in going down 3 rows) and it takes 25 days to replace each.
Thanks in advance for any and all help given!!!!
