Formula Drag until next Date.

[garypea123]

Good Afternoon,

I am looking for a formula in B3 which will look at C3 and if its a date will put this date in Column B3. The formula will then copy this data until the next date in Column C and repeat the same logic.

I do not have XLSBB.

I have manually simulated in Column A how it should look.

Manual Input	Formula
27/11/2022​		27/11/2022​
27/11/2022​
27/11/2022​		TEST1
27/11/2022​		TEST2
27/11/2022​		TEST3
27/11/2022​		TEST4
27/11/2022​		4555555​
27/11/2022​		555555​
27/11/2022​
28/11/2022​		28/11/2022​
28/11/2022​
28/11/2022​		TEST1
28/11/2022​		TEST2
28/11/2022​		TEST3
28/11/2022​		TEST4
28/11/2022​		4555555​
28/11/2022​		555555​
28/11/2022​
29/11/2022​		29/11/2022​

 

[JamesCanale]

I don't love using the "CELL" function. But this works. Dates are just numbers to excel.

MrExcelPlayground14.xlsx
	B	C
2	11/27/2022	11/27/2022
3	11/27/2022
4	11/27/2022	Test1
5	11/27/2022	Test2
6	11/27/2022	Test3
7	11/27/2022	Test4
8	11/27/2022	4555555
9	11/27/2022	555555
10	11/27/2022
11	11/28/2022	11/28/2022
12	11/28/2022
13	11/28/2022	Test1
14	11/28/2022	Test2
15	11/28/2022	Test3
16	11/28/2022	Test4
17	11/28/2022	4555555
18	11/28/2022	555555
19	11/28/2022
20	11/29/2022	11/29/2022
Sheet21

Cell Formulas
Range	Formula
B2:B20	B2	=IF(LEFT(CELL("format",C2),1)="D",C2,B1)

 

[garypea123]

Thats great - Works a dream!! - Thank you very much for you help...