Hello all,
I am trying to create a table used to calculate weekends for a chart. Right now I just use a range that encompasses an entire year, but that is kind of sloppy, and will need updating as the year progresses. Is there a way to make a date accumulator table such that I can enter the first and last date of the range into corresponding cells, and have a table dynamically list the days within the range, and output Boolean results for weekends?
For instance, in my example, I cant just make A2 = G1, and then A3 = A2+1, since either formula overwrites the other. Also, this won't set a target end of the range. I am open to creative solutions!
Thanks!
Bookmarks