ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¸ß°Ý"©u"ªº¤½¦¡

¸ß°Ý"©u"ªº¤½¦¡

Dear ¥ý¶i,
·Q½Ð°Ý¤@¤U¡A§Ú¦bexcel AÄæ¦ì¦³³\¦h¤é´Á¡A§Ú·Q¦bBÄæ¦ì³]©w¤½¦¡(¦Û¤v¥i¥H±a¥X©u)¡A¤½¦¡­n«ç»òªí¥Ü¡H

A                      B
2017/5/1       2017Q2
2017/9/21     2017Q3
2017/10/1     2017Q4
2017/11/22  2017Q4
2018/1/8       2018Q1

Thanks!
Just do it.

¦^´_ 1# jsc0518


    ¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/QYVmuX
E0146_1.png
2018-1-8 16:06

TOP

¦^´_ 1# jsc0518

=YEAR(A1)&LOOKUP(MONTH(A1),{1,4,7,10},{"Q1","Q2","Q3","Q4"})  ¤U©Ô

TOP

=YEAR(B2)&"Q"&INT((MONTH(B2)-1)/3)+1
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# joblyc017

½Ð°Ý¤@¤U¡A¤p§Ì¤£¬O«ÜÀ´¡A¦³§¹¾ãªº¤½¦¡¥i¥H°Ñ¦Ò¶Ü¡H
Just do it.

TOP

¦^´_ 4# hcm19522

TEST OK¡A·PÁ±zªº¤À¨É
Just do it.

TOP

¦^´_ 3# aer

    TEST OK¡A·PÁ±zªº±Ð¾É
Just do it.

TOP

¦^´_ 1# jsc0518
Àx¦s®æB1¿é¤J
=YEAR(A1)&"Q"&ROUNDUP(MONTH(A1)/3,0)
½Ð°Ñ¦Ò!

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD