Help Excel Date Formula

Microsoft Excel 2010
October 3, 2010 at 07:55:52
Specs: Windows Vista
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????


edited by moderator: Title Edited To Be More Specific

See More: Help Excel Date Formula

Report •

October 3, 2010 at 08:37:32
Read up on Calculation operators and precedence,
I believe that is the point of the formula.

The { [ characters are there as a visual aid.


Report •

October 3, 2010 at 08:49:24
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


(40057.00 - 39814.00)/7 = 34.71428571

I hope that helps!

Report •

October 4, 2010 at 09:38:51
thank you very much, that did the trick!

Report •

Related Solutions

Ask Question