Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 12/20/2004 Posts: 7
|
I want to write formulae for specific dates. What is the method?
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 4,308
|
Close on December 31, 2004 would be:
C'12/31/04'
Make sure to use single quotes and the mm/dd/yy date convention.
- Doug Teaching Online!
|
|
Registered User Joined: 12/20/2004 Posts: 7
|
Thank you Doug. I am still not clear when I need to add a period? Also, could you give me an example of the new yearly high on a specific date. Thanks.
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Check out this thread on PCF examples. I think you will find examples of everything you need there:
Handy PCF example formulas to help you learn the syntax of PCFs!
- Craig Here to Help!
|
|
Guest-1 |