Welcome to the MacNN Forums.

l008com · Mar 7, 2008, 04:00 AM

Hey
I have a spreadsheet in NeoOffice that has a column of dates.
Is it possible to come up with a formula for the next column over, that will display the number of days between [NOW] and the date in the previous column? This would be very handy. thanks.

wataru · Mar 7, 2008, 08:00 AM

If the cells are set to date format, then you can calculate differences between dates simply by subtracting one from the other. Then the question is how to set a cell to "now." That I'm not sure. Have you checked for a function, like DATE() or something?

peeb · Mar 7, 2008, 10:20 AM

I don't know NeoOffice that well, but I'm presuming it has the same functions as Excel - there will be a function called NOW, or something like that, and a formula for calculating dates - have you poked around in the formula section?

philm · Mar 7, 2008, 12:02 PM

In Excel:

=NOW()-A1

will give you the difference in days between today and the date in cell A1.

l008com · Mar 7, 2008, 12:53 PM

B2 = NOW() - A2
where A2 = 3/6/08
B2 = 12/31/99

wtf? NOW() along does give me todays date.

l008com · Mar 7, 2008, 01:12 PM

=ROUND(DAYS(NOW();A2))

OK This is the last formula i came up with. It actually works in the 'formula builder' thing, but in my spread sheet, it gives me a date, now 1/1/00. In the formula builder it tells me '2' which is the right answer.

l008com · Mar 7, 2008, 01:14 PM

OK i got it. Formatting is kind of weird, the column is formatted as a number, but the individual cell was still formatted as a date. strange.

philm · Mar 7, 2008, 04:44 PM

Excel likes to take a guess at how you want your cells formatted. You are subtracting two dates, so it guesses you need it formatting as a date. A bit strange, but sort of logical.

JKT · Mar 7, 2008, 04:59 PM

Except that I008com is using NeoOffice

l008com · Mar 12, 2008, 10:54 PM

I'm back. Hows about getting the sum of an entire column? Clicking on the column header while editing the formula doesn't do anything.

l008com · Mar 12, 2008, 10:56 PM

also, why would this formula be giving me "#VALUE!" ???

=SUM((C4:C53)*50)

turtle777 · Mar 12, 2008, 11:07 PM

Originally Posted by l008com

=(SUM(C4:C53)*50)

Fixed for ya !

-t

JKT · Mar 16, 2008, 02:09 PM

Originally Posted by l008com

also, why would this formula be giving me "#VALUE!" ???

=SUM((C4:C53)*50)

That occurs when the column isn't wide enough to display the result, fwiw.

turtle777 · Mar 16, 2008, 06:05 PM

Originally Posted by JKT

That occurs when the column isn't wide enough to display the result, fwiw.

Are you sure ?

Because this is definitely a formula error in Excel.
The syntax of the formula is wrong.

-t

JKT · Mar 18, 2008, 06:29 PM

My mistake - you're right - it is ### when the column is too narrow for the value.