Create new column based on if then date logic

[Anonymous]

Hello. John and Betty (column 1) both built houses.

John started building his house on 11/20/15 (column 4).

His house was not completed until 6/1/17 (column 5).

In this data set, the original home value (column 6) is being calculated form a build date, and I want to find the home value from the first 36 months after the build has been completed.

John's home is showing it was originally valued at $1, but the new value I want to show ($36) is what appears in column 6 after 36 months. 

6/1/17 + 35 months = 5/1/2020 = $36.

I want that $36 value to show up in a new column (column 7) every time John's name appears in column A.

Additionally, Betty has also built a house but she has not owned it for a full 36 months, only 33 (column C). Because of this, we can't value her home at 36 months, so the new value (column 7) should show up as null every time Betty's name appears in column 1.

Appreciate the help on this one.

Home Owner	Months completed	Total Months Completed	Build Date	Completion Date	Build Date Value $	New 36month Value $
John	6/1/2017	1	11/20/2015	6/1/2017	1	36
John	7/1/2017	2	11/20/2015	6/1/2017	2	36
John	8/1/2017	3	11/20/2015	6/1/2017	3	36
John	9/1/2017	4	11/20/2015	6/1/2017	4	36
John	10/1/2017	5	11/20/2015	6/1/2017	5	36
John	11/1/2017	6	11/20/2015	6/1/2017	6	36
John	12/1/2017	7	11/20/2015	6/1/2017	7	36
John	1/1/2018	8	11/20/2015	6/1/2017	8	36
John	2/1/2018	9	11/20/2015	6/1/2017	9	36
John	3/1/2018	10	11/20/2015	6/1/2017	10	36
John	4/1/2018	11	11/20/2015	6/1/2017	11	36
John	5/1/2018	12	11/20/2015	6/1/2017	12	36
John	6/1/2018	13	11/20/2015	6/1/2017	13	36
John	7/1/2018	14	11/20/2015	6/1/2017	14	36
John	8/1/2018	15	11/20/2015	6/1/2017	15	36
John	9/1/2018	16	11/20/2015	6/1/2017	16	36
John	10/1/2018	17	11/20/2015	6/1/2017	17	36
John	11/1/2018	18	11/20/2015	6/1/2017	18	36
John	12/1/2018	19	11/20/2015	6/1/2017	19	36
John	1/1/2019	20	11/20/2015	6/1/2017	20	36
John	2/1/2019	21	11/20/2015	6/1/2017	21	36
John	3/1/2019	22	11/20/2015	6/1/2017	22	36
John	4/1/2019	23	11/20/2015	6/1/2017	23	36
John	5/1/2019	24	11/20/2015	6/1/2017	24	36
John	6/1/2019	25	11/20/2015	6/1/2017	25	36
John	7/1/2019	26	11/20/2015	6/1/2017	26	36
John	8/1/2019	27	11/20/2015	6/1/2017	27	36
John	9/1/2019	28	11/20/2015	6/1/2017	28	36
John	10/1/2019	29	11/20/2015	6/1/2017	29	36
John	11/1/2019	30	11/20/2015	6/1/2017	30	36
John	12/1/2019	31	11/20/2015	6/1/2017	31	36
John	1/1/2020	32	11/20/2015	6/1/2017	32	36
John	2/1/2020	33	11/20/2015	6/1/2017	33	36
John	3/1/2020	34	11/20/2015	6/1/2017	34	36
John	4/1/2020	35	11/20/2015	6/1/2017	35	36
John	5/1/2020	36	11/20/2015	6/1/2017	36	36
John	6/1/2020	37	11/20/2015	6/1/2017	37	36
John	7/1/2020	38	11/20/2015	6/1/2017	38	36
John	8/1/2020	39	11/20/2015	6/1/2017	39	36
John	9/1/2020	40	11/20/2015	6/1/2017	40	36
John	10/1/2020	41	11/20/2015	6/1/2017	41	36
John	11/1/2020	42	11/20/2015	6/1/2017	42	36
John	12/1/2020	43	11/20/2015	6/1/2017	43	36
Betty	3/1/2018	1	11/28/2017	3/1/2018	1	null
Betty	4/1/2018	2	11/28/2017	3/1/2018	2	null
Betty	5/1/2018	3	11/28/2017	3/1/2018	3	null
Betty	6/1/2018	4	11/28/2017	3/1/2018	4	null
Betty	7/1/2018	5	11/28/2017	3/1/2018	5	null
Betty	8/1/2018	6	11/28/2017	3/1/2018	6	null
Betty	9/1/2018	7	11/28/2017	3/1/2018	7	null
Betty	10/1/2018	8	11/28/2017	3/1/2018	8	null
Betty	11/1/2018	9	11/28/2017	3/1/2018	9	null
Betty	12/1/2018	10	11/28/2017	3/1/2018	10	null
Betty	1/1/2019	11	11/28/2017	3/1/2018	11	null
Betty	2/1/2019	12	11/28/2017	3/1/2018	12	null
Betty	3/1/2019	13	11/28/2017	3/1/2018	13	null
Betty	4/1/2019	14	11/28/2017	3/1/2018	14	null
Betty	5/1/2019	15	11/28/2017	3/1/2018	15	null
Betty	6/1/2019	16	11/28/2017	3/1/2018	16	null
Betty	7/1/2019	17	11/28/2017	3/1/2018	17	null
Betty	8/1/2019	18	11/28/2017	3/1/2018	18	null
Betty	9/1/2019	19	11/28/2017	3/1/2018	19	null
Betty	10/1/2019	20	11/28/2017	3/1/2018	20	null
Betty	11/1/2019	21	11/28/2017	3/1/2018	21	null
Betty	12/1/2019	22	11/28/2017	3/1/2018	22	null
Betty	1/1/2020	23	11/28/2017	3/1/2018	23	null
Betty	2/1/2020	24	11/28/2017	3/1/2018	24	null
Betty	3/1/2020	25	11/28/2017	3/1/2018	25	null
Betty	4/1/2020	26	11/28/2017	3/1/2018	26	null
Betty	5/1/2020	27	11/28/2017	3/1/2018	27	null
Betty	6/1/2020	28	11/28/2017	3/1/2018	28	null
Betty	7/1/2020	29	11/28/2017	3/1/2018	29	null
Betty	8/1/2020	30	11/28/2017	3/1/2018	30	null
Betty	9/1/2020	31	11/28/2017	3/1/2018	31	null
Betty	10/1/2020	32	11/28/2017	3/1/2018	32	null
Betty	11/1/2020	33	11/28/2017	3/1/2018	33	null

[mangaus1111 · Accepted solution]

Hi @Anonymous ,

I don´t know if I have well understood the logic.

You can find my pbi file here

https://1drv.ms/u/s!Aj45jbu0mDVJi0mCXzbYm_x0836N?e=FwflhI

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.