its my first question here..............
I have 100s of dates in column A. I want to record next Sunday on 1st day of any month.
in cell B1 I putted a formula
=IF(AND(WEEKDAY(A:A)=1,DAY(A:A)=1),A:A) then dragged it in B column, then I have got required dates and FALSE values.
then in C1 I used a formula
=MIN(B:B) I get exact required date.
but I need it in a single formula so I applied a formula
=MIN(IF(AND(WEEKDAY(A:A)=1,DAY(A:A)=1),A:A)) but it did not work.
I am wondering if anyone help me get it in a single formula correctly. thanks! regards, HR