| View previous topic :: View next topic |
| Author |
Message |
moski
Joined: 23 Jan 2009
Posts: 9
|
 Posted: Thu Aug 06, 2009 3:42 pm Post subject: spreadsheet functions |
 |
|
Im not a Excel guru 
But can you guys see anything wrong with this:
=DATEVALUE("23 SEP 2009")-TODAY()&" DO ALOT OFF STUFF"
All i get is #SYNTAX! |
|
| Back to top |
|
 |
Martin Aignesberger
Site Admin
Joined: 11 May 2005
Posts: 4867
|
| Posted: Fri Aug 07, 2009 8:21 am Post subject: |
|
|
I'm also no Excel guru, and AM-Notebook is not Excel, it has only a simple spreadsheet that cannot be really compared to Excel.
But what happens when you use =DATEVALUE("23.09.2009") instead of =DATEVALUE("23 SEP 2009") ?
_________________
Martin Aignesberger [SUPPORT] |
|
| Back to top |
|
|
moski
Joined: 23 Jan 2009
Posts: 9
|
| Posted: Mon Aug 10, 2009 2:08 pm Post subject: |
|
|
I had the same line of thinking and tried that before posting.
I also, just to be sure, tried it again.
Same result, #SYNTAX! |
|
| Back to top |
|
|
Martin Aignesberger
Site Admin
Joined: 11 May 2005
Posts: 4867
|
| Posted: Mon Aug 10, 2009 3:12 pm Post subject: |
|
|
| Quote: | | =DATEVALUE("23.09.2009") |
The format of that date is dependent of the windows date configuration. You have to enter it in the date format that is configured in your Windows...
If I enter the formula above, the date is correctly converted...
And with which version of AM-Notebook does this happen?
_________________
Martin Aignesberger [SUPPORT] |
|
| Back to top |
|
|
moski
Joined: 23 Jan 2009
Posts: 9
|
| Posted: Mon Aug 10, 2009 5:05 pm Post subject: |
|
|
If a use the =TODAY() i get 2009-08-10.
So that is the format i should use i guess.
Still get the #SYNTAX!
Im using AM-Notebook 5.1.1 |
|
| Back to top |
|
|
Martin Aignesberger
Site Admin
Joined: 11 May 2005
Posts: 4867
|
| Posted: Tue Aug 11, 2009 8:35 am Post subject: |
|
|
What's the exact formula you have entered?
_________________
Martin Aignesberger [SUPPORT] |
|
| Back to top |
|
|
moski
Joined: 23 Jan 2009
Posts: 9
|
| Posted: Wed Aug 12, 2009 5:39 pm Post subject: |
|
|
| Martin Aignesberger wrote: | | What's the exact formula you have entered? |
=DATEVALUE("2009-09-23") -TODAY()&" days left to Thailand" |
|
| Back to top |
|
|
Martin Aignesberger
Site Admin
Joined: 11 May 2005
Posts: 4867
|
| Posted: Thu Aug 13, 2009 9:07 am Post subject: |
|
|
I think I could figure out and fix a bug in the DATEVALUE function.
In the next version of AM-Notebook (5.2.0) the following formula should work:
| Code: | | =(DATEVALUE("2009-09-23") - DATEVALUE(TODAY())) & " days left to Thailand" |
With the current version 5.1.x it's unfortunately not possible.
_________________
Martin Aignesberger [SUPPORT] |
|
| Back to top |
|
|
moski
Joined: 23 Jan 2009
Posts: 9
|
| Posted: Fri Aug 14, 2009 8:02 pm Post subject: |
|
|
Oki !
Thanks for the time and effort !
Keep up the good work, it´s a great proggie |
|
| Back to top |
|
|
|
FAQ
Search
Register
Profile
Log in
