Formula to check A1 format (General or Date) then return B1 OR C1 depending on A1's formatting?

[Event2020]

Can the following be done with a excel formula as I am unable to get it right?

I am using Excel 2007 on Windows.

If cell A1 is formatted as 'General' then return the contents of cell B1 but if A1 is formatted as a 'Date' then return the contents of cell C1.

I can find a lot of information on how to format a cell depending on what it contains (conditional formatting) but in my case the cell is already formatted (either General or Date) and I need the formula to return the contents of either Cell B1 or C1 depending on how A1 is formatted.

Many thanks.

 

[Marcílio_Lobão]

Event2020, Good evening.

I'm not sure if the CELL function can help you.

Take a look at help of Excel for CELL --> format --> function.

But try to use:

=IF(CELL("format",A1)="G",B1,C1)

I hope it helps.