Thread: how can i get the date & time format 2010/02/17 12:05 in excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default how can i get the date & time format 2010/02/17 12:05 in excel
Try
=SUMPRODUCT((TEXT(I3:I71,"mmyyyy")="032010")*(H3:H 71))

--
Jacob


"NarenSelva" wrote:

I would like to share my knowledge by improving & clearing my doubts.
Reply With QuoteReply With Quote