Formula if today is nth month of quarter

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

#12

09-13-2020, 06:09 PM

Marcia

Windows 7 32bit Formula if today is nth month of quarter

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 554

Quote:

Originally Posted by Purfleet

Just my effort, =IF(MOD(MONTH(I2),3)=1,F2,"")

Thanks Purfleet. I replaced the ($I2) to (TODAY() in C2. It returned blank when it should return the value in $F$1

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:49 PM.