# 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

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.

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

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

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

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"?

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

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

You didn't like my solution?

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

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

Good deal. Thanks for the feedback!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1