Posted to microsoft.public.excel.misc
|
|
Extracting Dates
We are almost the
=IF(DAY(E)<12,G2,E2)
not
=IF(DAY(E2<12),G2,E2)
--
Gary's Student
"nandin11" wrote:
Hi,
Thank you for your reply. Something does not seem to be working and I
am sure it's an oversight on my part. I have 11-Jan-67 in E2 and
14-Jan-67 in G2 and in H2 =IF(DAY(E2<12),G2,E2) and yet it still
returns the value of 11-Jan-67. Is there some special formatting I
should follow?
Thank you.
--
nandin11
------------------------------------------------------------------------
nandin11's Profile: http://www.excelforum.com/member.php...o&userid=34840
View this thread: http://www.excelforum.com/showthread...hreadid=545875
|