G
Gene Moirao
Hi, (Excel 2007)
I'm in the US, created 2 tabs, 1 with US dates (formatted as DATE) and the
other tab with UK dates (also formatted as DATE).
File sent to UK to enter dates (dd/mm/yyyy)
=MONTH works find pulling out months from US dates, but fails on some UK
dates.
FAILS on =month(13/1/2010) #VALUE! but ok with =month(12/1/2010). I suspect
it is failing because it's "out of date range".
My goal is to pull out the month from all UK dates.
THANK for your help!
Gene
I'm in the US, created 2 tabs, 1 with US dates (formatted as DATE) and the
other tab with UK dates (also formatted as DATE).
File sent to UK to enter dates (dd/mm/yyyy)
=MONTH works find pulling out months from US dates, but fails on some UK
dates.
FAILS on =month(13/1/2010) #VALUE! but ok with =month(12/1/2010). I suspect
it is failing because it's "out of date range".
My goal is to pull out the month from all UK dates.
THANK for your help!
Gene