Monthly Differences in Price for Seasonal Analysis

SBF12345

Well-known Member
Joined
Jul 26, 2014
Messages
614
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?
 

Some videos you may like

Excel Facts

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

NeonRedSharpie

Well-known Member
Joined
Jul 14, 2014
Messages
1,678
Table 1: A1:B4

1/1/20141
1/31/20141.2
2/1/20141.3
2/28/20141.8

<tbody>
</tbody>

Table 2: E1:G3

12
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
Joined
Jul 26, 2014
Messages
614
Table 1: A1:B4

1/1/20141
1/31/20141.2
2/1/20141.3
2/28/20141.8

<tbody>
</tbody>

Table 2: E1:G3

12
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,177
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top