What exactly happens with your formula?I have the current date format and cannot get a count between two dates. Here is my formula:
You can, as long as it's written in a format consistent with your PC's regional settings for date formats.Welcome, i don't know if you can put the date/time value directly in to the formula
It does't matter how the cells are 'formatted'.I made sure the cells are in date format and not text or number.