accuterm excel formula

001 S
002 0
003 FORMULA
004
005
006
007
008 A;'=SUM(A1..A35)'
009 L
010 15

Thank you for any help you can offer!

This is what I am trying to do.  G2 is the email date column.  

This is what I get

One issue you're going to have is that  each formula is going to be hard coded to row 2.  If you copied the formula from row 2 to the other ones in Excel it would modify them.  To get around that try this:

=IF(INDIRECT("G" & ROW())  <> "", TODAY() - INDIRECT("G" & ROW()), "")

As to why you're getting 45063, I can't tell.  I'd list the file to the screen to see what's actually coming from the formula and you might also want to post the Excel spreadsheet.

Thank you.  I tried the indirect formula but received the same results.  I will set up a small data file and test proc so that I can share everything in the post though I may not get to it today.

Here is the proc and dict item I am using.  I have attached the resulting xlsx file.  The formula in column A is not overlaid by my proc so that is my current work around.  Column I 'age.c' is where the dict item is not interpreting the formula in the a-correlative.

I couldn't get it to work on my system.  I have a test file named JUNK with 7 attributes in it. Attribute 2 has a date in it in external format so I don't have to iconv it. I'm basically trying to download using the attribute list "01 03 04 05 06 07 02 AGE.C".  If I do it to a CSV or TAB delimited file and open it with Excel it works. The formula is in column H and it calculates the number of days from today and whatever is in column G. I can also create a new XLS spreadsheet directly and that also works.

The problem comes when I try  to add the !!B2:Y746 at the end of the spreadsheet name.  I'm getting an "Invalid Delimiter" error instead of getting anything in the spreadsheet. It seems like I got it to work once but haven't been able to duplicate it since.  It could be a bug but it's also possible I'm doing something wrong.

I should also note that I'm probably using an old version of the file transfer programs since we haven't upgraded them in a long long time. If it's a bug it may already have been fixed.

What worked for me was wrapping the formula in double quotes and then using it as a string within the dictionary. I also had to ensure that the formula was properly formatted to avoid errors when it was processed. It took a bit of trial and error, but once I got the syntax right, it worked smoothly.

I was in the same boat a while ago, and honestly, learning more advanced Excel tips really helped. I found some great resources through Excel TV’s Best Excel Courses https://excel.tv/best-excel-courses/. It really boosted my confidence when handling tricky formula issues like this one.