Formula if today is nth month of quarter

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

FAQ

Thread Tools

Display Modes

09-07-2020, 10:56 PM

Marcia

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

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

Formula if today is nth month of quarter

Hi. I would like help in creating the formula in A2 like this:
=IF(Today falls within the first month of today's quarter,$F1,"")
Like, today is the 3rd month of this quarter so the formula should return blank.

Thank you.

« Previous Thread | Next Thread »

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:46 AM.