If Current Month

Karrie Davis · 09/04/19

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å · 09/06/19

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, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome · 09/09/19

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

If Current Month

Comments

Help Article Resources

Categories