Hello there!
I am trying to calculate the number of days remaining in a month from the Output Date.
So, for example, the output date is 18/08/2020 - what formula could I use to calculate the number of remaining days from the 18/08/2020 to the end of the month, 31/08/2020.
The output date can be any date of the year so the calculation would need to check what month it is in and how many days in that month.
Any help would be appreciated.
Thanks