New
#1
Excel help
I need some help with excel
I run a library with the help of an excel sheet.
I put the date of return in the spreadsheet.
I have the types of item in a spreadsheet, drop down box.
Book= 21 school days
Dvd= 3 school days
CD= 7 Days
Is it possible that I can run a formula that says when xxx is selected in the drop down the appropriate return date is selected. I want this to include weekends where the school is closed.
Thanks
Harry Cross