Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling data for every 3rd day

Status
Not open for further replies.

wrburch

Vendor
Aug 7, 2012
9
US
Is there a formula that will allow me to pull data just for every third day in a date range? For example, my end date is today and I want to go backwards to Jan 1st for every 3rd day. This will be a daily report that would give each shift (A,B,C) their cumulative report for data.
Thanks for any help!
 
Do you mean every calendar day including weekends and holidays?

-LB
 
Thanks for the help. Had to do some minor modification to the formula but works great.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top