How can I properly display netdays?

Brandon Morales

Hi, i have a data sheet which is pulling a date linked from another sheet. in the cell below the date, im trying to right a formula that displays the number of days from the date to today- its not working… any ideas here? My formula is showing invalid data type.

Jgorsich

Your column is formatted as a date (this is necessary) and you are trying to display an integer, it won't work in that column. Make a new column right next to it though formatted to the default Text/Number and it will work fine.

Brandon Morales

ok, makes sense. thank you!