Formula if today is nth month of quarter

		Microsoft Office Forums > Microsoft Excel > Excel
Formula if today is nth month of quarter

09-07-2020, 11:33 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter	PrincessApril	Excel	6	12-06-2019 02:38 PM
Format in a formula month and numbers	Marcia	Excel	10	02-28-2019 05:55 AM
Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date	mshu31	Word	1	02-09-2017 02:04 PM
Formula For Displaying Exact Days of the Month	ddhawks	Excel	2	07-12-2016 11:48 PM
Formula to divide if no of days in month is 28	shilabrow	Excel	5	06-26-2014 12:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:41 PM.