Date Formula Question
Hello, I am creating a formula to pull the month out and then if the date is blank to have the field be blank. Here is the formula I am using:
=MONTH([Activity End Date]@row, IF(ISBLANK([Activity End Date]@row, " ")))
However, I am receiving an "Invalid Data Type" response. I've attached a screen print. If the Activity End Date is blank, I want the "Month" column to be Blank.
Help Article Resources
Check out the Formula Handbook template!