date reading formula question
 

I am re organizing a data so that I can use a pivot table. On the import
page the data is "June-02-2004 08:00 A" and I am wanting to only use the
month and year. I use this formula =LEFT('Activity Data Import'!E3,12) to
put the data on a worksheet to build the pivot table from.

It returns June-02-2004

and was using this formula =DATE(YEAR(G3),MONTH(G3),1) to get the month
and year from that. This formula returns #VALUE! I get #VALUE! even if I
remove the formula and type in the date.

Can someone tell me what I can do to fix this?


Thanks,


Todd

date reading formula question
 

I got it. It wasn't excel or the formula, it was the export that created the
data. I changed the date format in the export and the formula reads
correctly now.

Thanks.

"Todd" wrote:

I am re organizing a data so that I can use a pivot table. On the import
page the data is "June-02-2004 08:00 A" and I am wanting to only use the
month and year. I use this formula =LEFT('Activity Data Import'!E3,12) to
put the data on a worksheet to build the pivot table from.

It returns June-02-2004

and was using this formula =DATE(YEAR(G3),MONTH(G3),1) to get the month
and year from that. This formula returns #VALUE! I get #VALUE! even if I
remove the formula and type in the date.

Can someone tell me what I can do to fix this?


Thanks,


Todd