# Monthly Differences in Price for Seasonal Analysis

#### SBF12345

##### Well-known Member
I would like to find differences in price between the first and last days of calendar months. I am having trouble with this task. How is best to approach separating dates or defining dates for input into the calculation of their corresponding prices?

### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

#### NeonRedSharpie

##### Well-known Member
Table 1: A1:B4

 1/1/2014 1 1/31/2014 1.2 2/1/2014 1.3 2/28/2014 1.8

<tbody>
</tbody>

Table 2: E1:G3

 1 2 First Last

<tbody>
</tbody>

(Note: 1 and 2 denote month)

Formula:

First:
Code:
``=VLOOKUP(DATE(2014,F\$1,1),\$A:\$B,2,0)``
Last:
Code:
``=VLOOKUP(EOMONTH(DATE(2014,F\$1,1),0),\$A:\$B,2,0)``

#### SBF12345

##### Well-known Member
Table 1: A1:B4

 1/1/2014 1 1/31/2014 1.2 2/1/2014 1.3 2/28/2014 1.8

<tbody>
</tbody>

Table 2: E1:G3

 1 2 First Last

<tbody>
</tbody>

(Note: 1 and 2 denote month)

Formula:

First:
Code:
``=VLOOKUP(DATE(2014,F\$1,1),\$A:\$B,2,0)``
Last:
Code:
``=VLOOKUP(EOMONTH(DATE(2014,F\$1,1),0),\$A:\$B,2,0)``

Thanks!

Replies
0
Views
103
Replies
3
Views
22
Replies
22
Views
147
Replies
7
Views
125
Replies
1
Views
43