View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blatham
 
Posts: n/a
Default DSUM with Criteria containing non-hardcoded values?


No probs

you can do

="=" & TEXT(J2,"dd/mm/yy")

to change the format of the date


--
blatham
------------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441
View this thread: http://www.excelforum.com/showthread...hreadid=493129