Microsoft Office Forums - View Single Post - [Solved] Formula if today is nth month of quarter

Thread: [Solved] Formula if today is nth month of quarter

View Single Post

Old

09-13-2020, 06:09 PM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2013

Marcia uses Office 2013

Office 2013

Expert

The original poster

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Quote:

Originally Posted by Purfleet

View Post

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

Reply With Quote