Thread: [Solved] Formula if today is nth month of quarter
View Single Post
 
Old 09-07-2020, 10:56 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Reply With Quote