Can I change first and last effective dates?

Yes. Include the Replace First Effective Start Date and Replace Last Effective End Date attributes in the spreadsheet template, as appropriate. Spreadsheet users set these attributes to Y and provide revised dates on the Effective Start Date and Effective End Date attributes.

For some objects, you can change only one of these dates.