Formula if today is nth month of quarter

Marcia · #1 09-13-2020, 06:09 PM

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

Purfleet · #2 09-13-2020, 09:44 PM

you need to attach examples otherwise i can only guess what one you have changed

Column A was checking the date in Column I and returning the month in Column F if you wanted the first month of the quart to show, column B did the second month of the quarter and column C did the third quarter.

I have no idea on how your data is laid out so i dont know where its going wrong

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