Users input projects they are working on every day with a date.
How can I produce a report that looks like the following: (user would select a date range)
Week of User Project worked on
June 2 - 8
Spongebob Ordered krabby patties
Patrick Jelly Fishing
Mr. Crabs Payroll
Employee of the Month
June 9 - 15
Would like all the weeks displayed, even if no projects are displayed.
I would rather not have a table with all the weeks of the year if possible.
Can VBA spit out the weeks (June 2 - 8) by it self and display users and projects if the date falls in the week range?