1

Currently, I am creating a calculated column called Next Meeting Due

This column is linked to 2 other columns:

Meeting Frequency -> (which can be monthly, 6 monthly and annually)

Last Meeting Date -> (last meeting)

My current formula is:

=IF([Meeting Frequency]="6 Monthly",[Last Meeting Date]+182)

This works perfectly fine, however when adding multiple if statements for Monthly/Annually it doesn't work.

In my head the following formula should work:

=IF([Meeting Frequency]="6 Monthly"
    ,[Last Meeting Date]+182
   )
   ,[Meeting Frequency]="Monthly"
   ,[Last Meeting Date]+30 

If anyone has a solution or can point out what I have done wrong please let me know.

This also doesn't work:

=IF([Meeting Frequency]="6 Monthly"
    ,[Last Meeting Date]+182
   )
   ,IF([Meeting Frequency]="Monthly"
       ,[Last Meeting Date]+30
      )
  • 1
    Always start in Notepad and format your Formula with linebreaks and indents. I did this for your formulas so you can spot yourself where your syntax is wrong – Danny '365CSI' Engelman Jan 27 '16 at 11:38
1

The formula should be like this

=IF([Meeting Frequency]="6 Monthly",[Last Meeting Date]+182,IF([Meeting Frequency]="Monthly",[Last Meeting Date]+30))

You will need to use nested if in calculated column, your first if statement's closing bracket need to be at end.

1

I tested this formular:

=IF([Meeting Frequency]="6 Monthly"
        ,DATE(YEAR([Last Meeting Date])
                    ,MONTH([Last Meeting Date])+6
                    ,DAY([Last Meeting Date])
              )
        ,IF([Meeting Frequency]="Monthly"
            ,DATE(YEAR([Last Meeting Date])
                    ,MONTH([Last Meeting Date])+1
                    ,DAY([Last Meeting Date])
                  )
            )
    )

and here is the output:

enter image description here

Thanks to Danny who posted this link to fix the offset.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.