Date Help

[want2learn]

I have a training document with course names across the top in columns A through O and certification titles in columns P through S.
I am trying to find a formula to put the word “Complete” in the cell P2 when cells A through E have dates in them. The same formula would be used for cell Q2, when 5 dates are entered into F through J and so on.

 

[etaf]

you could count to see if the range has any blank cells
=COUNTBLANK(A3:E3)
=COUNTBLANK(A3:E3)=0
If(COUNTBLANK(A3:E3)=0, "complete","NOT")

Or counta()

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2	1	1	1	1	1											complete
3	1	1	1	1	1											complete
Sheet1

Cell Formulas
Range	Formula
P2	P2	=IF(COUNTA(A2:E2)=5,"complete","not")
P3	P3	=IF(COUNTBLANK(A3:E3)=0, "complete","NOT")

 

[want2learn]

Thanks etaf! I will give that a try.

 

[want2learn]

An additional question. This formula works if the cells are in sequential order A2:E2, what if they are separated. Looking for cells with dates in cells A2, A4, A8, A16?

 

[Joe4]

I have unmarked your last question as the solution.
When marking a solution, you should:
- only mark a post if your original question was answered to your satisfcation
- only mark the actual post that contains the solution to the original question (do not mark your own post acknowledging that nother post solved your issue, or any other post that does not contain the solution).

 

[want2learn]

I see I made an error in the question above. I am working in rows, so the cells should have been A2, B2, D2, & F2.

This is the formula I ended using and I also added an "IF" formula to mark it "Complete" in the cell P2.

=COUNTA(A2,B2,D2,F2)=4
=IF(COUNTA(A2,B2,D2,F2)=4,"Complete","")