Calculating Weeks, Weekday nights and Weekend nights

Please, upload an example workbook with desired inpt and output.

Originally Posted by DonkeyOte

From what I can tell the Demo works, no ?

(NETWORKDAYS.INTL is exclusive to XL2010 and beyond)

Ok but you get an idea of what i'm trying to do, i have a check-in date and check-out date, using these two dates i need to find out the number of weekday nights(SUN-THU) and number of weekend Nights(FRI-SAT).

I'm sorry if i offended you, i will post a new thread for the 3 week requirement.

Hello,
I'm developing a register for a hostel, given two set of dates (check-in and check-out), i need to have a message popup whenever the stay is exceeded by 3 weeks.I would really appreciate if you could help me out with this one:

Please See DEMO File.

If ((F2>3) OR ((F2 = 3) AND ((E2 >1) OR (D2>1)))) then
MsgBox (" Stay Cannot Exceed 3 Weeks !!! ")
End if

Except F2,E2,D2 are all columns with 54 rows, so when the user enters the check-in date and check-out date, D2 , E2 , F2 are computed and the macro should immediately alert the user if the above conditions are met.I'm really new to VBA, if you could code the macro for me that would be great.

Thanks
AV