季度获取 - 我的帆软

季度获取

IF(RIGHT(A3,2) IN ("01","02","03"),"Q1",IF(RIGHT(A3,2) IN ("04","05","06"),"Q2",IF(RIGHT(A3,2) IN ("07","08","09"),"Q3","Q4")))

这样写获取年月所属的季度公式不合格，应该怎么写？

FineReport LOE 发布于 2023-7-19 10:44

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

LTC朝Lv6高级互助
发布于2023-7-19 10:47（编辑于 2023-7-19 10:50）

获取日期中的月份值 month(today())

---------------------------------------------

IF(OR(MONTH(TODAY()) = 1, MONTH(TODAY()) = 2, MONTH(TODAY()) = 3), "Q1",

IF(OR(MONTH(TODAY()) = 4, MONTH(TODAY()) = 5, MONTH(TODAY()) = 6), "Q2",

IF(OR(MONTH(TODAY()) = 7, MONTH(TODAY()) = 8, MONTH(TODAY()) = 9), "Q3", "Q4")))

1592Lv6高级互助
发布于2023-7-19 10:48

roundup(month(today())/3)

3关注人数

214浏览人数

最后回答于：2023-7-19 10:50

活动推荐更多

热门课程更多

确定取消