Hello all,
I have a huge worksheet with multiple dates listed like this...
1/1/2001
1/2/2001
1/3/2001
...
3/16/2016
on another tab I have
Monday,
Tuesday,
Wednesday,
Thursday,
Friday
I want to put a formula in the cell next to the weekday that basically says if date = Monday give me sum of all Mondays.
same for Tuesday... etc.
Please help!
Thank you all.
Bookmarks