its my first question here..............

Que.:-
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

record next Sunday on 1st day of any month". Can you be more specific, and especially can you give examples of input and desired output -- by providing an example of the dates in column A, and where and what you want for output. – Ron Rosenfeld Feb 14 '15 at 15:27