coliervile
Well-known Member
- Joined
- May 19, 2006
- Messages
- 724
Good morning everyone. How can I get column B to fill down with Day 1, Day 2, or Day 3 and so on skipping holiday dates?
Column A1 and B1:
Column A1 and B1:
10/1/2014 DAY 1
10/2/2014 DAY 2
10/3/2014 DAY 3
10/6/2014 DAY 4
10/7/2014 DAY 5
10/8/2014 DAY 6
10/9/2014 DAY 7
10/10/2014 DAY 8
10/13/2014 Columbus Day
10/14/2014 DAY 9
10/15/2014 DAY 10
10/16/2014 DAY 11
10/17/2014 DAY 12
10/20/2014 DAY 13
10/21/2014 DAY 14
10/22/2014 DAY 15
10/23/2014 DAY 16
10/24/2014 DAY 17
10/27/2014 DAY 18
10/28/2014 DAY 19
10/29/2014 DAY 20
10/30/2014 DAY 21
10/31/2014 DAY 22
11/3/2014 DAY 23
11/4/2014 DAY 24
11/5/2014 DAY 25
11/6/2014 DAY 26
11/7/2014 DAY 27
11/10/2014 Veterans Day
11/11/2014 DAY 28
11/12/2014 DAY 29
11/13/2014 DAY 30
11/14/2014 DAY 31
11/17/2014 DAY 32
11/18/2014 DAY 33
11/19/2014 DAY 34
11/20/2014 DAY 35
11/21/2014 DAY 36Best regards,
Charlie