How Create Decade Field Calculated

Question

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?

Anders Aune · Accepted Answer · 2012-10-28 09:12:05Z

1

Maybe you could use FLOOR for this:

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

answered Oct 28, 2012 at 9:12

Anders Aune

6,2781 gold badge23 silver badges31 bronze badges

Add a comment |

1 Answer 1