getting the dates??
 

I have a formula
=BLPSH("JPY Curncy","PX_LAST","31/12/2007",,,BLP|H!'JPY Curncy,[PX_LAST]
ST=20071231 END=20071231 PD=D')
I have to change the date for each cell 31/12/2007
how can I Just change one cell and the rest of the cells would pick that
date without dragging because it would not work. it should be automatic???
thank you

getting the dates??
 

Put the date in a cell, say M1, and use

=BLPSH("JPY Curncy","PX_LAST",M1,,,BLP|H!'JPY Curncy,[PX_LAST] ST=20071231
END=20071231 PD=D')


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"yaseen" wrote in message
...
I have a formula
=BLPSH("JPY Curncy","PX_LAST","31/12/2007",,,BLP|H!'JPY Curncy,[PX_LAST]
ST=20071231 END=20071231 PD=D')
I have to change the date for each cell 31/12/2007
how can I Just change one cell and the rest of the cells would pick that
date without dragging because it would not work. it should be automatic???
thank you