Hi,
I have sheet with three dates columns, column A="Date in", Column B="Date cleared" and Column C ="Date out"
I need to work out how many days there are between "Date in" & "Date out" then times the number by $10, I need to exclude Sundays though in the count between the two dates, then what I also need is if there is a date entered into the "Date Cleared" column excel should ignore the "Date In" and instead work out how many days between "Date Cleared and "Date out" also excluding Sundays. Is there a formula that can do this or will this have to be done in VBA?
Thanks in advance.
Bookmarks