If Current Month

Karrie Davis

Hi I'm trying to write a formula that will show me a column for the current Month 

 

Currently formula

=If(Month(date column)= 9, [Project]1)- This works and displays the correct cell, however I want the column to change with the month so I tried= IF(Month(date column)=Month(Today()), [Project]1), I get an error

 

Any suggestions.

 

Thanks

Andrée Starå

Hi Kari,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

What error is being generated? Can you post the exact formula?