pulling back dates that meet certain criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Calculation problem 3
Calculate next workday after adding calendar days to date in cell 13
Date Calculation Formula- Calendar days minus Holidays 1
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Alternative formula to exclude holiday calculation 6
business days - trade date plus 3 2
How to calculate dates 6
Date formula 1

Back
Top