If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

#1
May 19th 06, 12:33 AM posted to microsoft.public.excel.worksheet.functions
 South texas man external usenet poster Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

I need to calculate on a spreadsheet the number of days between a specific
date and the date the spread sheet is opened.
I need to know the number of days a merchandise has been stored.
#2
May 19th 06, 12:41 AM posted to microsoft.public.excel.worksheet.functions
 Bob Phillips external usenet poster Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

=TODAY()-A1

where A1 holds that date, and format as general

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"South texas man" <South texas > wrote in
message ...
> I need to calculate on a spreadsheet the number of days between a specific
> date and the date the spread sheet is opened.
> I need to know the number of days a merchandise has been stored.

#3
May 19th 06, 03:59 PM posted to microsoft.public.excel.worksheet.functions
 South texas man external usenet poster Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

it did not work. B9 has the date it arrived at whse. I9 is the cell that I
need to have the number of days since merchandise arrived. Ex arrived on
05/10/06. the I9 should read "9". With the formula =TODAY()-B9 it reads
"01/22/00"

"Bob Phillips" wrote:

> =TODAY()-A1
>
> where A1 holds that date, and format as general
>
> --
> HTH
>
> Bob Phillips
>
> (remove xxx from email address if mailing direct)
>
> "South texas man" <South texas > wrote in
> message ...
> > I need to calculate on a spreadsheet the number of days between a specific
> > date and the date the spread sheet is opened.
> > I need to know the number of days a merchandise has been stored.

>
>
>

#4
May 19th 06, 08:01 PM posted to microsoft.public.excel.worksheet.functions
 Kevin Vaughn external usenet poster Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

Format that cell as general

--
Kevin Vaughn

"South texas man" wrote:

> it did not work. B9 has the date it arrived at whse. I9 is the cell that I
> need to have the number of days since merchandise arrived. Ex arrived on
> 05/10/06. the I9 should read "9". With the formula =TODAY()-B9 it reads
> "01/22/00"
>
> "Bob Phillips" wrote:
>
> > =TODAY()-A1
> >
> > where A1 holds that date, and format as general
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove xxx from email address if mailing direct)
> >
> > "South texas man" <South texas > wrote in
> > message ...
> > > I need to calculate on a spreadsheet the number of days between a specific
> > > date and the date the spread sheet is opened.
> > > I need to know the number of days a merchandise has been stored.

> >
> >
> >

#5
May 19th 06, 08:37 PM posted to microsoft.public.excel.worksheet.functions
 South texas man external usenet poster Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

Sorry,
I don't know what I did wrong, it worked. THANKS!!!!

"South texas man" wrote:

> it did not work. B9 has the date it arrived at whse. I9 is the cell that I
> need to have the number of days since merchandise arrived. Ex arrived on
> 05/10/06. the I9 should read "9". With the formula =TODAY()-B9 it reads
> "01/22/00"
>
> "Bob Phillips" wrote:
>
> > =TODAY()-A1
> >
> > where A1 holds that date, and format as general
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove xxx from email address if mailing direct)
> >
> > "South texas man" <South texas > wrote in
> > message ...
> > > I need to calculate on a spreadsheet the number of days between a specific
> > > date and the date the spread sheet is opened.
> > > I need to know the number of days a merchandise has been stored.

> >
> >
> >

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post How do I add a range by date over 90 days older than today John DeLosa Excel Discussion (Misc queries) 4 February 16th 06 09:30 PM Count number of days between dates BUT IF null to current date kathi Excel Worksheet Functions 1 February 14th 06 04:11 PM how to calculate a date .. say 34 days from today shaunl Excel Discussion (Misc queries) 5 July 13th 05 02:38 PM Formula to count number of days in range which are less than today zooming Excel Worksheet Functions 2 June 21st 05 04:01 PM Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM

All times are GMT +1. The time now is 02:15 AM.