Looking for ideas

viper · Feb 26th, 2002, 10:14 PM

How can I test for the number of weeks between two cells that contain dates? I have the date 2/27/02 in cell "b5" and the date 3/27/02 in cell "A1", how can write a formula to take the number of days between those two cells and divide by 7 to give me a number of weeks?

Feb 26th, 2002, 10:35 PM

=(A1-B5)/7

viper · Feb 26th, 2002, 11:07 PM

Thanks,

Just wasn't thinking about a simple formula, thought I needed something more but it worked great.

Thanks again,

Feb 26th, 2002, 10:14 PM	#1
viper Board Regular Join Date: Feb 2002 Location: Jefferson City, Missouri Posts: 383	How can I test for the number of weeks between two cells that contain dates? I have the date 2/27/02 in cell "b5" and the date 3/27/02 in cell "A1", how can write a formula to take the number of days between those two cells and divide by 7 to give me a number of weeks? __________________ I appreciate the help from everyone at Mr. Excel. viper

Feb 26th, 2002, 11:07 PM	#3
viper Board Regular Join Date: Feb 2002 Location: Jefferson City, Missouri Posts: 383	Thanks, Just wasn't thinking about a simple formula, thought I needed something more but it worked great. Thanks again, __________________ I appreciate the help from everyone at Mr. Excel. viper

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode