User:Vijinrassel

HOW TO MAKE WHOLE MONTH DATE IN EXCEL? COPY AND PAST THIS FORMULA

=IF(A3="";"";IF(MONTH(IF(TEXT(A3+1;"ddd")="Sun";A3+2;A3+1))=MONTH(A3);IF(TEXT(A3+1;"ddd")="Sun";A3+2;A3+1);""))

EXAMPLE :

First a3 cloumn you give ddate like 01/06/2017 and a4 past above formula