Thread: [Solved] Formula if today is nth month of quarter
View Single Post
 
Old 09-13-2020, 09:22 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Just my effort, =IF(MOD(MONTH(I2),3)=1,F2,"").


Change the 1 to 2 or 3 if you want it to return the 2nd month or third.


Not sure of the layout of the data, so not sure whay you want to return
Attached Files
File Type: xlsx Formula if today is nth month of quarter_purfleet.xlsx (10.6 KB, 6 views)
Reply With Quote