Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Please help | Excel Worksheet Functions | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
Year-to-date year to date formula | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
IF/AND Formula seems to only be reading 1st part of formula | Excel Worksheet Functions |