Skip cell if it does not meet the criteria

[751212512]

Hi,

I am currently working on a Gantt chart in excel.

I am after a formula that skips over cells that do not meet the criteria which end up being blank.

The current formula I am using is:

=if(and(GanttChart!D:D>=DATE(2023,1,1),GanttChart!D:D<=DATE(2023,1,31)),GanttChart!D:D,"")

The idea for this formula is to grab dates from column D in the "GanttChart" sheet and only display the ones that fall in January in the "January" sheet, disregarding all of the other ones.

But when I drag the formula down it displays blank cells for the cells that don't meet the criteria (dates that are in February). This can be seen in cells D12 and D14.

How do I remove these blank cells?

I believe the formula I am looking for is =iferror(index... and so on but I can not wrap my head around it and get it working

I am using google sheets as the formulas do not work on excel 2019 for some reason, but does on excel 2016 which I have on my work computer.

Any help is appreciated.

Screenshots included.

January Sheet.PNGMain Sheet.PNG

[Glenn Kennedy]

1. screenshots can't be edited. No-one will want to retype your stuff. Please read the yellow banner (top) and attach a sample file.

2. Confusion. Excel 2016, 2019 or GS. What Platfrom/product do you want this to work with? If it's GS, I will MOVE your thread to the GS sub-forum.