Support Board
Date/Time: Sat, 19 Apr 2025 09:45:11 +0000
QuoteSpreadsheet
View Count: 77
| [2025-03-18 21:04:44] |
| User841161 - Posts: 275 |
|
In a Quote Spreadsheeet, i am trying to subtract 2 different dates. For some reason the subtraction is not coming out how it should. I was wondering what I may doing wrong. I am trying to subtract n column's cells from the m column's cells. The m cells = "TODAY()", and the N columns are the actual expiration dates manually typed, so n5= "2025-04-16". The difference,N5-m5, should be 29, not 64 as cell o5 indicates.
|
 3-18-2025.PNG / V - Attached On 2025-03-18 21:04:22 UTC - Size: 69.93 KB - 21 views |
| [2025-03-18 22:33:09] |
| John - SC Support - Posts: 39362 |
|
How are you entering the date in column n (i.e. how are you entering "2025-04-16")? And how are you doing the subtraction? What is the formula? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-03-20 14:29:58] |
| User841161 - Posts: 275 |
|
I figured out my problem, sorry to waste your time on this one..
|
To post a message in this thread, you need to log in with your Sierra Chart account: