Calculated date column in using multiple IF-Statements

Question

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
      )

Answer 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.

Answer 2

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:

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