Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
Hi i need a formula to find low value between two dates.
for example.
low between 5 july 2008 to 18 july 2008.
can anyone help me with this formula urgently.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
There is more than enough information on this forum about working with dates to help you along....
I suggest you enter two dates, the start date and the end date, then use something like:
valuewhen(1,enddate,lowestsince(1,startdate,LOW));
to return the desired value.
Hope this helps.
wabbit [:D]
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
