Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel help

27 May 2011   #1

Windows 7 Home Premium
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.


Harry Cross

Attached Files
File Type: zip Lib Issue (10.1 KB, 4 views)
My System SpecsSystem Spec
27 May 2011   #2

Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)

The current document is not going to work and here is why:
You return date formula is based on the function "Today".

Let's say a student takes a book today for 21 days, when you open this file tomorrow, the return day would be recalculated for 21 days from tomorrow, so those days would be always shifting in time - always 21 days ahead, no matter when you open the documents.

So here is what I propose:
Make one more column: Date Taken (Start date) to write the date when an item was taken.
Reduce Return Date column to one and use several enclosed IF functions, which would depend on item selected in drop down menu.

Because school is closed on weekends, a student is not able to return an item, so we would use "business days" instead calendar days. Forumula =WORKDAY(StartDate,Days,Holidays) works like a charm here if we use only first part =WORKDAY(StartDate,Days).

If you want to use calendar days you can simply use StartDate+N, where N is number of days for book, dvd, cd correspondingly.

Check out attachment - I have implemented all of that in there
(with business days, not calendar days).

Attached Files
File Type: zip (50.6 KB, 5 views)
My System SpecsSystem Spec
28 May 2011   #3

Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)

HAWC145 thank you for positive reputation. I guess this as well as your comment means that we can close this issue and marked it as solved? Please let us know.
My System SpecsSystem Spec


 Excel help

Thread Tools

Similar help and support threads
Thread Forum
Excel 2007 Files Are Now Saving with Fewer KB in Both Excel 2007 and 2
The “problem” I’m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb. I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit. The W700 has Office 2007 and theW541 has Office 2013. Both versions ofExcel are 32 bit as far as I...
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 18:10.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App