Hello, sorry one more question on this, it is currently returning the short date and we would like the long date.

I have changed it to 'true' and changed the date format to match the windows regional settings but am getting a 'DateError'.

=@AddDaysToDate(date(true), 'DD MMMM YYYY', 7)

Are you able to help with this?