Fill text and count of days based date

[razaas]

Hi,
Please help me with a proper formula, with the below sample formula "=IF(WEEKDAY(A2)<=5,"Vacation day "&SUMPRODUCT((WEEKDAY($A$2:A2)<=5)*1),"Weekend")" I have achieved partial result, but i need to get the result as shown in the column c in the sample below. Thanks

Coulmn A Column B Column C
1-Jan Vacation day 1 Holiday 1
2-Jan Vacation day 2 Vacation day 1
3-Jan Vacation day 3 Vacation day 2
4-Jan Weekend Weekend
5-Jan Weekend Weekend
6-Jan Vacation day 4 Vacation day 3
7-Jan Vacation day 5 Vacation day 4
8-Jan Vacation day 6 Vacation day 5
9-Jan Vacation day 7 Vacation day 6
10-Jan Vacation day 8 Vacation day 7
11-Jan Weekend Weekend
12-Jan Weekend Weekend
13-Jan Vacation day 9 Holiday 2
14-Jan Vacation day 10 Holiday 2
15-Jan Vacation day 11 Vacation day 8
16-Jan Vacation day 12 Vacation day 9
17-Jan Vacation day 13 Vacation day 10

[José Augusto]

Hi

Suppose your date in B2.B_n and a holiday list in H2:H29 (extend as needed)

Use in C2 and drag down

Please Login or Register  to view this content.

See the file for clarification

[razaas]

Jose, Thanks a lot, it works as I desired. once again and have a nice day.

[José Augusto]

You are welcome and thanks for the feedback.

Do not forget to mark this thread as SOLVED, selecting Thread Tools from the menu link above