excel date range help please
Posted
by
Mark
on Super User
See other posts from Super User
or by Mark
Published on 2012-07-10T08:03:11Z
Indexed on
2012/07/10
9:17 UTC
Read the original article
Hit count: 205
I need help with either a formula or a macro to help automate a grade sheets dates. We have class every monday or wednesday only. I would like to vlookup from a input table of each quarters date range (example Sept. 10 - Oct 24 and the code auto insert the date of every monday and wednesday in a row at the top of my grade sheet. Every year I use the same excel workbook I built to average and rate the grading with no problem, however i can't seem to get this one right. Any help would be greatly appreciated. Currently I have to enter each date by hand. Thanks Again for any help.
© Super User or respective owner