|
Login
  • Page:
  • 1

TOPIC: colonna date e numero trimestre

colonna date e numero trimestre 7 years 3 months ago #9787

  • Paperino
  • Paperino's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 67
  • Thank you received: 8
  • Karma: 6
Buongiorno,

avete una formula per assegnare ad una colonna di date il numero di quarter (trimestre) corrispondente?

Grazie

Attendo fiduciosa
The administrator has disabled public write access.

colonna date e numero trimestre 7 years 3 months ago #9788

  • Canapone
  • Canapone's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 1346
  • Thank you received: 160
  • Karma: 108
Ciao Paperino

=ARROTONDA.PER.ECC(MESE(A2)/3;0)

Una piccola curiosità: conosco aziende convinte che i quarter siano i quadrimestri :(

Saluti
The administrator has disabled public write access.
The following user(s) said Thank You: Paperino

colonna date e numero trimestre 7 years 3 months ago #9789

  • ninai
  • ninai's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 107
  • Thank you received: 25
  • Karma: 13
un caro saluto
come alternativa, anche:
=INT((MESE(A2)-1)/3)+1
The administrator has disabled public write access.
The following user(s) said Thank You: Paperino
  • Page:
  • 1
Time to create page: 0.486 seconds