Calculate Difference between Two Dates

[Anet_Gambina1]

Hello,

I have two Date fields that need to show the time remaining (in years/months). My attempts at declaring the correct formula have not been successful. Here’s a screenshot with the field outlined where I want to show the difference. I believe this is the closest I’ve come:

DATETIME_DIFF(TODAY(),Rent Commencement,Lease Expiration,‘Years’,‘Months’)

Thank you!

Anet Gambina

[ScottWorld]

@Andy_Barrows There is an extra parenthesis after the Start Date. You need to remove that. The formula should look like this:

DATETIME_DIFF({Start Date}, TODAY(), 'months')

[Justin_Barrett]

Thanks for catching that. Clearly I wasn’t on my best proofreading behavior that day. :slightly_smiling_face:

[benchappell]

Hi. Has anyone managed to work out how to calculate total number of hours worked between two dates (multiple weeks sometimes) but only including working hours e.g. Mon-Fri, 0900-1700 ?