COUNT THE NUMBER OF COLUMNS WHICH CONTAINS DATES

KempenUSA

I am looking for a formula which will count specific cells in a row which contains a date.

The formula would go into the "TOTAL CELLS WITH DATES" column.

RS-1 PO NEED DATE	RS-1 TOTAL (USD)	RS-2 PO NEED DATE	RS-2 TOTAL (USD)	RS-3 PO NEED DATE	RS-3 TOTAL (USD)	RS-4 PO NEED DATE	RS-4 TOTAL (USD)	TOTAL CELLS WITH DATES	TOTAL (USD)
7/16/2024		7/30/2024						2
7/16/2024		7/30/2024		8/15/2024		8/16/2024		4
7/16/2024		7/30/2024		8/15/2024				3

Aser

If your "NEED DATE" columns would only contain dates then you may use COUNT()

Example:

=COUNT([RS-1 PO NEED DATE]@row, [RS-2 PO NEED DATE]@row, [RS-3 PO NEED DATE]@row, [RS-4 PO NEED DATE]@row)

Aser

If your "NEED DATE" columns would only contain dates then you may use COUNT()

Example:

=COUNT([RS-1 PO NEED DATE]@row, [RS-2 PO NEED DATE]@row, [RS-3 PO NEED DATE]@row, [RS-4 PO NEED DATE]@row)

KempenUSA

@Aser Perfect, it worked. Thank you.