Thread
: [Solved]
Formula if today is nth month of quarter
View Single Post
09-13-2020, 06:09 PM
Marcia
Windows 7 32bit
Office 2013
Expert
Join Date: May 2018
Location: Philippines
Posts: 527
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
Marcia
View Public Profile
Find all posts by Marcia