NextMonth and Next Quarter ()
Hi All, I have a excel table which has due date. I am trying to identify the which all the rows that will be due in next month using the NextMonth(). But I am getting below error message. Can someone help me to fix this Nextmonth () ? Or Guide me how to calculate the rows has a due date as next month. Code Filing Due Date NextMonth Due Next Qtr Due 99M9 31-Jul-20 N N 1065 15-Jul-20 N N 1065 15-Aug-20 Y Y 5945 31-Mar-19 N N 3675 31-May-20 N N 6465 31-Mar-19 N N 3505 30-Sep-20 N Y 5055 30-Sep-20 N Y 1735 30-Sep-20 N Y 3815 31-Aug-20 Y Y 3815 31-Aug-20 Y Y 2885 31-May-20 N N
