Days remaining in the month calculation (1 Viewer)

[sashapixie]

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.

 

[sashapixie]

solved!!

=Day(DateSerial(Year([EmployeeStartDate]),Month([EmployeeStartDate])+1,0))-Day([EmployeeStartDate])