Forum Discussion
Need help on formula if there is. year and date month
hi I have a date column and there are some row that will have not date in it. I want to auto pick the date into MONTH in numbers with the formula =MONTH(date col) but how to show empty or 0...
=IFERROR(MONTH(C2),"")=IFERROR(IF(MONTH(C2)<=3,YEAR(C2)-1&"/"&RIGHT(YEAR(C2),2),YEAR(C2)&"/"&RIGHT(YEAR(C2)+1,2)),"")Maybe with these formulas in cells A2 and B2 in the example.