# Formula to get number based on sequence

1. ## Formula to get number based on sequence

Hello:

I have date data as shown in column A and corresponding number (data) in column B.
I need a formula in cell B8 to get me the number as above sequence.

Let me know if you have any questions.
Thanks.
Riz  Register To Reply

2. ## Re: Formula to get number based on sequence

Here's the data in your file:

Data Range
 A B 1 1/1/2014 2 2 1/2/2014 3 3 1/3/2014 4 4 1/4/2014 5 5 1/5/2014 6 6 1/6/2014 7 7 1/7/2014 8 8 11/16/2016 9 ------ ------

Tell us what result you expect in B8.  Register To Reply

3. ## Re: Formula to get number based on sequence

Hello Tony:

I am expecting B8 = 1058
Please let me know if you have any questions.
Thanks.

Riz  Register To Reply

4. ## Re: Formula to get number based on sequence

Not sure I understand the logic but this is what I used to get the result of 1058.

=A8-A1+B7  Register To Reply

5. ## Re: Formula to get number based on sequence

Hi Tony:

My mistake, B8 needs to be 1052.
Hello:

Sorry for misunderstanding.
Lets see if this makes it clear.
I have
A2 = 1/1/2014 and i need formula in cell B2 to give number 2
A3 = 1/2/2014 and i need formula in cell B3 to give number 3
A2 = 1/3/2014 and i need formula in cell B4 to give number 4
A5 = 1/4/2014 and i need formula in cell B5 to give number 5

and so on

Please let me know if you have any questions.
Thanks.

Riz  Register To Reply

6. ## Re: Formula to get number based on sequence

 A B C 1 1/1/2014 2 B1: =A1 - "12/30/13" 2 1/2/2014 3 3 1/3/2014 4 4 1/4/2014 5 5 1/5/2014 6 6 1/6/2014 7 7 1/7/2014 8 8 11/16/2016 1052

Your question could hardly be more cryptic, riz. How about just "elapsed days"?  Register To Reply

7. ## Re: Formula to get number based on sequence

Hi shg and Tony:

I got it figured out.
Convert column A dates into number and then start B2 = A2-41638 and copy down.

Thanks

Riz  Register To Reply

8. ## Re: Formula to get number based on sequence

You didn't like my solution?  Register To Reply

9. ## Re: Formula to get number based on sequence

Hi sng:

Yes i liked your solution but i posted and figured out the solution as above just before you posted the solution.
Great logic, will work.
Thanks a lot.
Riz  Register To Reply

10. ## Re: Formula to get number based on sequence

Good deal. Thanks for the feedback!   Register To Reply