Microsoft Excel 2010

I have to do this for class I have excel 2010, but the numbers are not coming out right. Help please? cell a-2 1/1/2009 cell b-2 9/1/2009 cell b-3 ={[(B2-A2)-280]/7}*-1

That is what is in the book it is to find out Babys gestational age in weeks. This formula would not work at all, I removed all the {[ and it worked but the sum is not correct, any ideas????

Thanks!

edited by moderator: Title Edited To Be More Specific

Read up on Calculation operators and precedence,

I believe that is the point of the formula.The { [ characters are there as a visual aid.

MIKE

We don't usually answer homework questions in this formula - unless the poster has given it a try and can't come up with a working solution. Since you've posted what you tried, we're willing to help.

Excel dates and times are stored internally as numbers, with the Integer portion of the number being the date, and the Decimal portion being the time.

Each integer represents 1 day, starting at 1/1/1900 on most systems.

If you enter a date (and time) in a cell and format it as a number, you'll see how many days (and fraction of a day) that date is from 1/1/1900

Now, since each integer is 1 day, if you subtract 1 date from another, you'll get the number of days. Divide that result by 7 and you get the number of weeks.

With your dates in A2 and B2...

=(B2-A2)/7 = 34.71428571

because...

(40057.00 - 39814.00)/7 = 34.71428571

I hope that helps!

thank you very much, that did the trick!

Ask Your Question

Weekly Poll

Do you think Slack's direct listing "IPO" is a good idea?

Discuss in The Lounge

Poll History