Wash Sale Formula
 

I have stock trades in a excel spreadshhet in which I need to look 30 days
previous and 30 days pat to see if that same security was traded - If so
figure the gain or loss of the 90 period of that security.

More info on your setup would be needed. Wash sales can?? be subjective.
some wash sale rules and suggestions.http://tinyurl.com/6nhx3
You could use a FINDNEXT looping macro to look at all instance of that
symbol to see if it met the criteria and report findings to you.
--
Don Guillett
SalesAid Software

"Rick" wrote in message
...
I have stock trades in a excel spreadshhet in which I need to look 30 days
previous and 30 days pat to see if that same security was traded - If so
figure the gain or loss of the 90 period of that security.