Search results

Open Office does NOT recognize DateDif. I have the Excel sheet working with DateDiff but will not work in Open Office. Since I am temporarily using both plus I share some spreadsheets with friends and family using OO, I was trying to change it to the long drawn out way but kept getting 26635...

Could some tell me why I get 26,000+ years from this formula using a date of 11/25/1947 in cell a14 ? Months and days 'seem' to work. I am trying to calculate years, months, and days from a birthdate and using Today(). I am trying the long way to use in both Excel and Open Office and OO does not...

Thanks. That works great.

Appears datediff will only do days, months, years. Looks like they didn't see fit to build in weeks to the possibilities. Thanks

Is there a way to calculate number of weeks from a begin date and end date ? Example. Cell D5 has a begin date and cell E5 has an end date. In cell G20, I would like to show the number of weeks (and left over days) from those dates if that is possible.

Worked after I took the third 'and' out since it was only testing one cell in the third part. In case it would be helpful to anyone else, it works as...

Ok, tried =IF(AND(ISNUMBER(I11),ISNUMBER(G11),ISNUMBER(E11)),SUM((E11+G11+I11)-(D11+F11+H11)),AND(ISNUMBER(E12),ISNUMBER(G12)),SUM((E12+G12)-(D12+F12)),AND(ISNUMBER(E12),SUM(E12-D12)),"") Says I've entered too many arguments for this function. tried each of the 3 parts separately and they...

Thanks Brian. That works on the N cell formula. How about the 3 if conditions ? Is that possible ? What I need is: If e9 has a number, then e9-d9. If e9 AND G9 both have a number then add e9, G9 minus D9, F9. If e9,G9,I9 all have data, then add e9,G9,I9 minus D9,F9,H9. ELSE "". Is that...

Now have ISNUMBER in all formulas. Will not calculate on any cell that is resulting in "" so I changed "" to 0 and they all work without #VALUE. Only thing is having zeros in all formula cells until data is input. Shame there isn't an alternative to "" that can be calculated. Also, can you...

It's because of the "" in the formulas, correct ? So I don't know how to get around having a blank cell and having it in a calculation.

Here is a simplified version of what I am trying to do. Only rows 9 and 10 rather than 13 and 14

First two work fine but the third (N13) gives a #Value until all cells are completed. And yes I put in the new formula in 13 and 14 cells. Would like to see results in N13 as they are completed.

Thanks. Makes sense. I will give that a try and let you know how it does.

In F13, I have this --> =IF(ISBLANK(E13),"",IF(SUM(E13-D13)>=0,ROUNDUP(SUM(E13-D13)/2,0)+D13,ROUNDDOWN(SUM(E13-D13)/2,0)+D13)) In K13 I have this --> =IF(ISBLANK(E13),"0",MEDIAN(4,-4,E13-D13)) Lastly in N13 I have this --> =IF(AND(ISBLANK(E13),ISBLANK(E14)),"",K13+L13+M13+K14+L14+M14) My...

This is what I have tried and as nearest I can get. SELECT tblpoints.frineed, tblpoints.fripull, IIf([fripull]<[frineed],[frineed]-Int(([frineed]-[fripull])/2),IIf([fripull]>[frineed],[frineed]+Int(([fripull]-[frineed])/2),[fripull])) AS satneed...

Working on a golf points (instead of stroke) calculator. I have run into a brick wall on trying to: Scenario: If I need 20 points on a given round and I pull 23, I am plus 3. I need to round that plus 3 up to 4, take half and add to the 20 needed which will make the next round needed 22. On...

Sorry ling for not getting back sooner. I had typed in the field name into the Control Source. Apparently it never recognized it for whatever reason nor did it give any error. Finally picked it from the list and it works. Thanks loads for the help and patience.

Like I said, probably would be easier to just have them input the day name as they input. Just thought it would be cute to auto do it. Thanks

Tried this, still doesn't save the day name to the table. I suppose the easiest thing to do would be have them input the day name (Mon, Tue, etc) as they go. I appreciate the help.

Thanks Mr. B. However, it does not save the result to the table. What am I missing ?