Try below formula in B2 and copy down:
Formula:
=IF((A3>=DATE(YEAR(A3),1,1))*(A3<=DATE(YEAR(A3),7,1)),TEXT(DATE(YEAR(A3),7,1),"mmm-yy"),TEXT(DATE(YEAR(A3),1,1),"mmm-yy"))
Try below formula in B2 and copy down:
Formula:
=IF((A3>=DATE(YEAR(A3),1,1))*(A3<=DATE(YEAR(A3),7,1)),TEXT(DATE(YEAR(A3),7,1),"mmm-yy"),TEXT(DATE(YEAR(A3),1,1),"mmm-yy"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks