Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have 12 months Dates from 31-12-2020 to 30-11-2021
I use =monthName(addmonths(max(Date_Email), -1))
when I select 31-12-2020 it shows Nov-2020.
I want to restrict this however Nov 2020 is not in my data.
Thanks
Hi @aghabdurauf, and why is the addmonths function with -1, you can add an If to check the date before creating it, but if you don't create the date the fist month of data won't be related to any date.