days to date

[Brian]

Howdy All,

I have an expiration date in cell c1. example 03/13/2007
I want to have 'days until expiration' in cell b1.

What formula will do this for me?

Thanks,
Brian

 

[Ron de Bruin]

Hi Brian

=C1-TODAY()

Format as General

 

[JE McGimpsey]

one way:

B1: =C1-TODAY()

Format as General.

 

[Brian]

Thank you very much, exactly as desired!

one way:

B1: =C1-TODAY()

Format as General.