Using Calculated dates in a Request Table

In the post before this one I explained how Excel can be used to easily calculate dates for doing event research. I have noticed that using these calculated dates by copying them in a new Datastream Request table worksheet in Excel does not always work very well. The dates may be automatically formatted when copied into the Excel worksheet.

There is an easy way to prevent Excel from formatting the new dates: save them as a text file and open them again in Excel as text. When you then copy the dates into the Datastream Request Table worksheet the dates are kept in the correct format and can be used for the Datastream search request. In the video (±1 min.) below it is explained how you can do this:

Author information: LinkedIn

10:49 PM - 9 December 2010