I'm trying to make a helper column of month number(Col F) to then make a column of monthly totals (Col G) using a formula like so =MONTH(LISA_INCOME[[#This Row],[DATE]])
Problem is that the column of dates does not have a date in each cell of that column, if there's a blank date the month number formula result shows "1"
Is there a way to adjust the above formula so that blank dates show blank months or even zero months so I can then maybe even use conditional formatting to hide the zero/blanks in the resulting month number column?
Bookmarks