I have been trying to figure out how to calculate weekend and weekday rates for a project but no luck. So hopefully someone can offer a little assistance.. this is my scenario..
A user enters in the date that a furniture item is returned as a string. the user also enters in the date it was due.. now supposed the furniture was due on 5/9/05 and returned on 5/18/05 i have 9 days the furniture is late. There is also different rates for weekends and weekdays. my problem is how do i first calculate the difference between the two dates.. then distinguish between weekend and weekday so that i could multiply those dates by the appropriate rates and produce a receipt... Any help would be appreciated...Im stuck!!