Forum Discussion
date calculation issues
Jo-AnnDP That's because the date columns contain texts. Your system doesn't recognize dates with the dot between the day, month and year.
Select the Birthdate column. On the Data ribbon select Text to Columns. Advance to step 3 without changing anything.
In Step 3 set the column type to Date and select DMY. Press Finish. That should transform the "dates with dots" to valid dates for your system settings.
Jo-AnnDP That's because the date columns contain texts. Your system doesn't recognize dates with the dot between the day, month and year.
Select the Birthdate column. On the Data ribbon select Text to Columns. Advance to step 3 without changing anything.
In Step 3 set the column type to Date and select DMY. Press Finish. That should transform the "dates with dots" to valid dates for your system settings.
