pulling back dates that meet certain criteria

B

bruno

does anyone know how i can retrieve trading days only from a list of dates
and codes that are returned (1 or 0) when the date is not a holiday or
weekend/
 
B

Bernie Deitrick

Bruno,

USe data / autofilter and filter your list to show just 1, then copy and paste somewhere else, or to
show 0 then delete the rows with 0.

HTH,
Bernie
MS Excel MVP
 
Top