Return values based on a start date and incremental dates after the start date

[nmurphy2]

If the raw data does not have a date exactly x months out, then choose the closest date to the +1 month, +3 months, etc.

Data is available from Dec 2019 to June 2020.  Some of the cells in the table below are blank because the date is past June 2020

Desired outcome:

		$ on - if available
Generic Code	Min Date	Min Date	Min Date + 1 Month	Min Date + 3 Months	Min Date + 6 Months	Min Date + 9 Months	Min Date + 12 Months	Today
Code 1	12/13/2019	$  31,410.25	$  31,938.54	$  24,490.13	$  29,642.69
Code 2	12/13/2019	$        150.33	$        157.19	$        147.86	$        181.31
Code 3	12/13/2019	$        781.61	$        838.87	$        628.38	$        810.90
Code 4	12/13/2019	$    1,363.94	$    1,408.75	$    1,172.66	$    1,399.45
Code 400	3/2/2020	$        191.41	$        128.56	$          10.60
Code 401	12/13/2019	$    3,177.45	$    3,137.34	$    1,639.17	$    2,240.88
Code 60	6/1/2020	$        329.27
Code 278	4/30/2020	$        147.58	$        170.58
Code 308	4/30/2020	$        112.51	$        116.80
Code 1007	6/1/2020	$          85.49

[v-jayw-msft]

Hi @nmurphy2 ,

The raw data is quite confusion. I can't find the column headers.

Best Regards,

Jay

[nmurphy2]

Pasting the data into this window and keeping the format has been difficult. One more try with a small snippet (because of the character limitations) DATE $ Code 12/13/2019 0:00 31410.247 Code 1 12/16/2019 0:00 31471.848 Code 1 12/17/2019 0:00 31421.45 Code 1 12/18/2019 0:00 31279.571 Code 1 12/19/2019 0:00 31499.852 Code 1 12/20/2019 0:00 31938.54 Code 1 12/23/2019 0:00 31738.797 Code 1 12/24/2019 0:00 31718.262 Code 1 12/25/2019 0:00 31718.262 Code 1 12/26/2019 0:00 31800.403 Code 1 12/27/2019 0:00 31878.805 Code 1 12/30/2019 0:00 31658.528 Code 1 12/31/2019 0:00 31828.403 Code 1 1/1/2020 0:00 31828.403 Code 1 1/2/2020 0:00 31794.801 Code 1 1/3/2020 0:00 31727.598 Code 1 1/6/2020 0:00 31770.532 Code 1 1/7/2020 0:00 31385.981 Code 1 1/8/2020 0:00 31680.93 Code 1 1/9/2020 0:00 31960.946 Code 1 1/10/2020 0:00 31938.54 Code 1 1/13/2020 0:00 32175.622 Code 1 1/14/2020 0:00 31964.676 Code 1 1/15/2020 0:00 32259.625 Code 1 1/16/2020 0:00 32646.047 Code 1 1/17/2020 0:00 33017.532 Code 1 1/20/2020 0:00 33017.532 Code 1 1/21/2020 0:00 32892.458 Code 1 1/22/2020 0:00 33290.083 Code 1 1/23/2020 0:00 33196.743 Code 1 1/24/2020 0:00 33081.004 Code 1 1/27/2020 0:00 32806.59 Code 1 1/28/2020 0:00 33284.481 Code 1 1/29/2020 0:00 31929.208 Code 1 1/30/2020 0:00 32669.383 Code 1 1/31/2020 0:00 31994.543 Code 1 2/3/2020 0:00 32470.571 Code 1 2/4/2020 0:00 32840.188 Code 1 2/5/2020 0:00 33344.215 Code 1 2/6/2020 0:00 33650.368 Code 1 2/7/2020 0:00 33433.825 Code 1 2/10/2020 0:00 33482.36 Code 1 2/11/2020 0:00 33222.879 Code 1 2/12/2020 0:00 33234.079 Code 1 2/13/2020 0:00 33622.368 Code 1 2/14/2020 0:00 33835.176 Code 1 2/17/2020 0:00 33835.176 Code 1 2/18/2020 0:00 33588.762 Code 1 2/19/2020 0:00 33835.18 Code 1 2/20/2020 0:00 33745.575 Code 1 2/21/2020 0:00 33336.75 Code 1 2/24/2020 0:00 32582.575 Code 1 2/25/2020 0:00 31208.633 Code 1 2/26/2020 0:00 31049.961 Code 1 2/27/2020 0:00 29407.204 Code 1 2/28/2020 0:00 28886.375 Code 1 3/2/2020 0:00 30428.325 Code 1 3/3/2020 0:00 28979.715 Code 1 3/4/2020 0:00 30687.805 Code 1 3/5/2020 0:00 29993.368 Code 1 3/6/2020 0:00 29709.618 Code 1 3/9/2020 0:00 28173.27 Code 1 3/10/2020 0:00 28826.637 Code 1 3/11/2020 0:00 27630.04 Code 1 3/12/2020 0:00 24490.133 Code 1 3/13/2020 0:00 27163.223 Code 1 3/16/2020 0:00 23020.125 Code 1 3/17/2020 0:00 24322.833 Code 1 3/18/2020 0:00 22106.54 Code 1 3/19/2020 0:00 22063.301 Code 1 3/20/2020 0:00 21065.125 Code 1 3/23/2020 0:00 20503.063 Code 1 3/24/2020 0:00 22738.157 Code 1 3/25/2020 0:00 23044.563 Code 1 3/26/2020 0:00 25764.645 Code 1 3/27/2020 0:00 24696.915 Code 1 3/30/2020 0:00 25907.512 Code 1 3/31/2020 0:00 25693.211 Code 1 4/1/2020 0:00 24384.868 Code 1 4/2/2020 0:00 24728.872 Code 1 4/3/2020 0:00 24168.692 Code 1 4/6/2020 0:00 26251.516 Code 1 4/7/2020 0:00 25745.848 Code 1 4/8/2020 0:00 26040.977 Code 1 4/9/2020 0:00 26791.02 Code 1 4/10/2020 0:00 26791.02 Code 1 4/13/2020 0:00 26228.958 Code 1 4/14/2020 0:00 27044.793 Code 1 4/15/2020 0:00 25873.672 Code 1 4/16/2020 0:00 25738.329 Code 1 4/17/2020 0:00 26520.329 Code 1 4/20/2020 0:00 26283.477 Code 1 4/21/2020 0:00 25116.114 Code 1 4/22/2020 0:00 26072.934 Code 1 4/23/2020 0:00 25550.348 Code 1 4/24/2020 0:00 26172.563 Code 1 4/27/2020 0:00 26734.629 Code 1 4/28/2020 0:00 26883.133 Code 1 4/29/2020 0:00 27415.118 Code 1 4/30/2020 0:00 27574.903 Code 1 5/1/2020 0:00 26396.262 Code 1 5/4/2020 0:00 27159.465 Code 1 5/5/2020 0:00 27411.36 Code 1 5/6/2020 0:00 27174.5 Code 1 5/7/2020 0:00 27777.922 Code 1 5/8/2020 0:00 27445.196 Code 1 5/11/2020 0:00 27183.903 Code 1 5/12/2020 0:00 26642.516 Code 1 5/13/2020 0:00 25298.454 Code 1 5/14/2020 0:00 25368.008 Code 1 5/15/2020 0:00 25349.211 Code 1 5/18/2020 0:00 25640.575 Code 1 5/19/2020 0:00 25020.243 Code 1 5/20/2020 0:00 25336.047 Code 1 5/21/2020 0:00 25061.598 Code 1 5/22/2020 0:00 25352.965 Code 1 5/25/2020 0:00 25352.965 Code 1 5/26/2020 0:00 26114.29 Code 1 5/27/2020 0:00 27195.176 Code 1 5/28/2020 0:00 27219.614 Code 1 5/29/2020 0:00 27537.305 Code 1 6/1/2020 0:00 27360.602 Code 1 6/2/2020 0:00 27868.149 Code 1 6/3/2020 0:00 28512.922 Code 1 6/4/2020 0:00 28191.477 Code 1 6/5/2020 0:00 30101.36 Code 1 6/8/2020 0:00 30293.098 Code 1 6/9/2020 0:00 29642.688 Code 1

[nmurphy2]

column names are Date, $, Code

[nmurphy2]

Raw data: DATE $ Code 12/13/2019 0:00 31410.247 Code 1 12/16/2019 0:00 31471.848 Code 1 12/17/2019 0:00 31421.45 Code 1 12/18/2019 0:00 31279.571 Code 1 12/19/2019 0:00 31499.852 Code 1 12/20/2019 0:00 31938.54 Code 1 12/23/2019 0:00 31738.797 Code 1 12/24/2019 0:00 31718.262 Code 1 12/25/2019 0:00 31718.262 Code 1 12/26/2019 0:00 31800.403 Code 1 12/27/2019 0:00 31878.805 Code 1 12/30/2019 0:00 31658.528 Code 1 12/31/2019 0:00 31828.403 Code 1 1/1/2020 0:00 31828.403 Code 1 1/2/2020 0:00 31794.801 Code 1 1/3/2020 0:00 31727.598 Code 1 1/6/2020 0:00 31770.532 Code 1 1/7/2020 0:00 31385.981 Code 1 1/8/2020 0:00 31680.93 Code 1 1/9/2020 0:00 31960.946 Code 1 1/10/2020 0:00 31938.54 Code 1 1/13/2020 0:00 32175.622 Code 1 1/14/2020 0:00 31964.676 Code 1 1/15/2020 0:00 32259.625 Code 1 1/16/2020 0:00 32646.047 Code 1 1/17/2020 0:00 33017.532 Code 1 1/20/2020 0:00 33017.532 Code 1 1/21/2020 0:00 32892.458 Code 1 1/22/2020 0:00 33290.083 Code 1 1/23/2020 0:00 33196.743 Code 1 1/24/2020 0:00 33081.004 Code 1 1/27/2020 0:00 32806.59 Code 1 1/28/2020 0:00 33284.481 Code 1 1/29/2020 0:00 31929.208 Code 1 1/30/2020 0:00 32669.383 Code 1 1/31/2020 0:00 31994.543 Code 1 2/3/2020 0:00 32470.571 Code 1 2/4/2020 0:00 32840.188 Code 1 2/5/2020 0:00 33344.215 Code 1 2/6/2020 0:00 33650.368 Code 1 2/7/2020 0:00 33433.825 Code 1 2/10/2020 0:00 33482.36 Code 1 2/11/2020 0:00 33222.879 Code 1 2/12/2020 0:00 33234.079 Code 1 2/13/2020 0:00 33622.368 Code 1 2/14/2020 0:00 33835.176 Code 1 2/17/2020 0:00 33835.176 Code 1 2/18/2020 0:00 33588.762 Code 1 2/19/2020 0:00 33835.18 Code 1 2/20/2020 0:00 33745.575 Code 1 2/21/2020 0:00 33336.75 Code 1 2/24/2020 0:00 32582.575 Code 1 2/25/2020 0:00 31208.633 Code 1 2/26/2020 0:00 31049.961 Code 1 2/27/2020 0:00 29407.204 Code 1 2/28/2020 0:00 28886.375 Code 1 3/2/2020 0:00 30428.325 Code 1 3/3/2020 0:00 28979.715 Code 1 3/4/2020 0:00 30687.805 Code 1 3/5/2020 0:00 29993.368 Code 1 3/6/2020 0:00 29709.618 Code 1 3/9/2020 0:00 28173.27 Code 1 3/10/2020 0:00 28826.637 Code 1 3/11/2020 0:00 27630.04 Code 1 3/12/2020 0:00 24490.133 Code 1 3/13/2020 0:00 27163.223 Code 1 3/16/2020 0:00 23020.125 Code 1 3/17/2020 0:00 24322.833 Code 1 3/18/2020 0:00 22106.54 Code 1 3/19/2020 0:00 22063.301 Code 1 3/20/2020 0:00 21065.125 Code 1 3/23/2020 0:00 20503.063 Code 1 3/24/2020 0:00 22738.157 Code 1 3/25/2020 0:00 23044.563 Code 1 3/26/2020 0:00 25764.645 Code 1 3/27/2020 0:00 24696.915 Code 1 3/30/2020 0:00 25907.512 Code 1 3/31/2020 0:00 25693.211 Code 1