Dates on sheets

Andre de Oliveira

Hi Community,

We have various tasks which are date driven (ie. the 15.01 or the 15.03 etc). Problem is, when i add the dates, the year gets attached (Ie. 15.01.2020 and 15.03.2020). As a result, these actions are only relevant for 2020 but this is in fact a yearly occurrence. Is there a way of noting the date without the year (15.01 instead of 15.01.2020)...?

Genevieve P.

Hi @Andre de Oliveira

You can configure your date columns per-sheet to have specific formatting, including using the Short Date, leaving out the year. (See our Help Center for more information on this, here.)

However, the cell itself will still be associated with the year you choose for the date initially, so if you are setting up automations/alerts based on these dates, you will need to adjust the year each January. Let me know if this makes sense or if I've misunderstood your question!

Cheers,

Genevieve