=DATE(YEAR(C2)+IF(MONTH(B2)>=MONTH(C2),1,2)-IF(MONTH(B2)-MONTH(C2)>=3,1,0),MONTH(B2)+1,0)
try this
=DATE(YEAR(C2)+IF(MONTH(B2)>=MONTH(C2),1,2)-IF(MONTH(B2)-MONTH(C2)>=3,1,0),MONTH(B2)+1,0)
try this
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks