days to date

's Computer Specifications

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

's Computer Specifications

Hi Brian

=C1-TODAY()

Format as General

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Brian" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>

's Computer Specifications

one way:

B1: =C1-TODAY()

Format as General.

In article <(E-Mail Removed)>,
"Brian" <(E-Mail Removed)> wrote:

> 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

's Computer Specifications

Thank you very much, exactly as desired!

"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> one way:
>
> B1: =C1-TODAY()
>
> Format as General.
>
> In article <(E-Mail Removed)>,
> "Brian" <(E-Mail Removed)> wrote:
>
>> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to pull <=14 Days, <=30 Days, >30 Days from a date column	Ken	Microsoft Excel Misc	3	23rd Oct 2009 12:53 AM
Conditional Formatting Dates calculating 10 days and 30 days from a certain date	Sioux	Microsoft Excel Worksheet Functions	2	11th Oct 2007 02:04 PM
Todays date minus 6 days before (Shows all records in 6 days)	=?Utf-8?B?UmFjaA==?=	Microsoft Access Queries	2	14th Sep 2007 12:46 PM
Determine dates by number of days, "what date is 180 days from now	=?Utf-8?B?VFJMYW1i?=	Microsoft Outlook Calendar	2	19th Apr 2007 03:30 PM
Business Days for based on a date of 7 days ago or longer	=?Utf-8?B?QmFyYmFyYQ==?=	Microsoft Access Queries	1	27th Oct 2003 09:26 PM