CODEWITHSUNDEEP
excelexcel-formulaexcel-dates
Ruth
Ruth

Reputation: 5

Add date to multiple cells based off another column in Excel

I'm trying to create a Pivot Table from this exported report. Screenshot:

enter image description here

However, each line does not have a date on it.

I've attempted to create a new column to add the dates to each line, but my formula only works on the first blank line. Any ideas?

Upvotes: 0

Views: 37

Answers (1)

Anar Iskenderli
Anar Iskenderli

Reputation: 16

Can this work for you?

=IF(ISBLANK(B3);C2;B3)

enter image description here

Upvotes: 0

Related Questions