Hello I'm having trouble creating a calculated field I managed to create a field that takes the date of an event

=YEAR([Event Date])

however I needed to create another calculated field, this needs to catch the decade of the year, but I have no idea how to do it.

is there any formula to create this type of field?

1 Answer 1


Maybe you could use FLOOR for this:

=FLOOR(YEAR([Event Date]),10)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.