How to fill down blank cell until it find the next date.

[haha97]

Hi. I want to copy Date1 column to Date2 column. For Date2 column, I want the date to fill down blank cell until it find the next date. I have tried IF function and it is not working properly.
Below is my table:

project_tracker.xlsx
	A	B
6	Date1	Date2
7	4/4/2022
8
9
10	11/4/2022
11
12
13
14
Sheet1

Desired output:

project_tracker.xlsx
	A	B
6	Date1	Date2
7	4/4/2022	4/4/2022
8		4/4/2022
9		4/4/2022
10	11/4/2022	11/4/2022
11		11/4/2022
12		11/4/2022
13		11/4/2022
Sheet1

 

[jtakw]

Hi,

Try this:

Book3.xlsx
	A	B
6	Date1	Date2
7	4/4/2022	4/4/2022
8		4/4/2022
9		4/4/2022
10	4/11/2022	4/11/2022
11		4/11/2022
12		4/11/2022
13		4/11/2022
14		4/11/2022
Sheet1075

Cell Formulas
Range	Formula
B7:B14	B7	=IF(A7<>"",A7,B6)

 

[haha97]

Hi,

Try this:

Book3.xlsx
	A	B
6	Date1	Date2
7	4/4/2022	4/4/2022
8		4/4/2022
9		4/4/2022
10	4/11/2022	4/11/2022
11		4/11/2022
12		4/11/2022
13		4/11/2022
14		4/11/2022
Sheet1075

Cell Formulas
Range	Formula
B7:B14	B7	=IF(A7<>"",A7,B6)

Thank you. It's working.

 

[jtakw]

You're welcome, thanks for the feedback.