Hi There
I'm trying to work out how to find the remaining days left in a month, I have this formula in Excel which works but when I transfer it to access it brings up an error.
=IF(R9C12="","",DAY(DATE(YEAR(R9C12),MONTH(R9C12)+1,0))-DAY(R9C12))
Any help would be appreciated.