Creating an Expiration Countdown

Robin M. Samaroo

Hello,

I need to create a tracker that counts down when a contract is going to expire. I am trying to use NETWORKDAYS function and it is not working for me. Does anyone have any suggestions on how I can do this?

Things to keep in mind is that this would be a living spreadsheet so the days to expiration would have to change as the dates change!

Thank you for your help and advice in advance! 😀

Mark Cronk

Hi Robin,

This should work for you. You can change the funtion to NETWORKDAYS if you don't want to include weekends. Change my [expiration date] to the name of your column with the expiration date. That column must be set with a date property. The column with the formula below needs to be a number/text column.

=NETDAYS(Today(), [expiration date]@row)

Work?

Mark