Using a Date format in a cell instead of a Text format to support a formula.

I am using the following formula where Cell A6 contains a date in TEXT format (i.e. 10-01-10)

=IFERROR(SUM(INDIRECT("'"&A6&"'!C3:E3")),"")

I want to have this same formula work with a cell that contains a date in a DATE format.

I had to put A6 as text as I couldn't get it to work as a date format.

Attached is a sample.

Columns ABC are a working copy in TEXT format. Columns EFG is an example of what I want to work with.

Thanks for any help.

Nick

You can use the TEXT function to convert the date value to date string:

Please Login or Register  to view this content.