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

jsc0518

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!

joblyc017

¦^´_ 1# jsc0518


    ¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/QYVmuX

¤U¸ü (70.22 KB)

2018-1-8 16:06

aer

¦^´_ 1# jsc0518

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

hcm19522

=YEAR(B2)&"Q"&INT((MONTH(B2)-1)/3)+1

jsc0518

¦^´_ 2# joblyc017

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

jsc0518

¦^´_ 4# hcm19522

TEST OK¡A·PÁ±zªº¤À¨É

jsc0518

¦^´_ 3# aer

    TEST OK¡A·PÁ±zªº±Ð¾É

p212

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