ContributionsMost RecentMost LikesSolutionsRe: Difference between datesPerfect. That worked. Thank you Mark. ------------------------------ James Ahearne ------------------------------ Re: Difference between datesMark Thank you so much for the fast response. Apologies, but I am having a little trouble making this work. I assume I only need to copy and paste your formula and link the correct [Date Responded] field (which is the same field noted twice). I've then tried to link the [Initial Date] field but I am told that the system is 'expecting a duration but found a number'. I am not sure why when I am linking it to a date field. Many thanks ------------------------------ James Ahearne ------------------------------ Difference between datesI wonder if anyone could help? I'm looking to set up a formula that shows- The difference between an initial date and the earlier of a) today's date or a specified date. I.e- Bob introduces a site 01.01.2020. We respond within 7 days (and record that date in the system- 08.01.2020) which returns a result of 7. However, if we haven't responded, yet, and the date is say 12.01.2020 it records a figure of 11. Thank you. ------------------------------ James Ahearne ------------------------------