# ActionDetails_Str

VALUE:
The American date: [%AmericanDate]
The Danish date: [%DanishDate] --> [%DanishDateConv]
The Spanish date: [%SpanishDate] --> [%SpanishDateConv]


# Actions

NOTES:
Create a new Excel workbook to populate some data to base the fictive calculations on


NOTES:
Write an English formatted date in Excel
Using the Excel formula to format it as a string to make sure Excel does not translate it. IMPORTANT: This is only for the sake of the exercise, normally this is not done.


NOTES:
Write an Danish formatted date in Excel
Using the Excel formula to format it as a string to make sure Excel does not translate it. IMPORTANT: This is only for the sake of the exercise, normally this is not done.


NOTES:
Write an Spanish formatted date in Excel
Using the Excel formula to format it as a string to make sure Excel does not translate it. IMPORTANT: This is only for the sake of the exercise, normally this is not done.


NOTES:
Retrieve the American-formatted date variable


NOTES:
Retrieve the Danish-formatted date variable


NOTES:
Retrieve the Spanish-formatted date variable


NOTES:
Create a new variable with American format to store the converted value from the DanishDate variable


NOTES:
Convert the Danish-formatted variable to the new variable


NOTES:
Create a new variable with American format to store the converted value from the SpanishDate variable


NOTES:
Convert the Spanish-formatted variable to the new variable


NOTES:
Create a variable to store the difference between the dates


NOTES:
Retrieve the difference between the American date and the Spanish date


NOTES:
Create a variable to generate a new date variable adding days to the Danish variable


