Entering UK dates in Sharepoint List and then using DateDif in calc column

Hi GuyCarnegie,

you can try these options:

1. Adjust regional settings:
- Go to the Site Settings of your SharePoint Online site.
- Under the "Site administration" (Site settings) section, click on "Regional settings."
- Choose a locale that matches the UK date format (dd/MM/yyyy).
- save these changes

2. Update existing dates:
- Switch to grid mode in your SharePoint list.
- Manually edit the existing date values in the UK date format (dd/MM/yyyy).
- Save the changes.

3. Modify calculated column formula:
- Identify the calculated column that uses the DATEDIF function.
- Update the formula to include the correct reference to the date column and adjust it to handle the UK date format.
- you can try this formula

`=DATEDIF([YourDateColumn], Today(), "d")`.

* Replace `[YourDateColumn]` with the internal or display name of your date column.
- This formula calculates the number of days between the date in your column and the current date.

4. Test and validate:
- Save the changes to the calculated column formula.
- Verify if the calculated column now displays the expected result, taking into account the updated UK date format.
- Test with different scenarios to ensure the DATEDIF function handles the date calculations correctly.