Thread
: [Solved]
Formula if today is nth month of quarter
View Single Post
09-07-2020, 11:33 PM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 873
Code:
=IF(MONTH(TODAY()) = 3*INT((MONTH(TODAY())-1)/3)+n,$F1,"")
where n is quarter month number, you want the formula to return the result for (1, 2, or 3)
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets