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.

 convert dates to number of days
 Author Name Remember Me? Password
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## convert dates to number of days

 Thread Tools Display Modes
#1
September 28th 05, 12:18 PM
 milk0s external usenet poster Posts: n/a
convert dates to number of days

Hi,

I am trying to work out a formula to covert rolling dates to number of days
into a seperate row in EXCEL to save me manually working out the number of
days between reults to make a comparison between two sets of data starting at
different points in the year but running for a similar number of days.

e.g.
Data Set 1
01/01/05=day 1
07/01/05=day7
01/02/05=day32
etc.

Data Set 2
17/04/05=day1
21/04/05=day4
27/04/05=day10
etc.

If anyone can help me on this one I would be most grateful

Thx

#2
September 28th 05, 12:50 PM
 Roger Govier external usenet poster Posts: n/a

Hi

Simply subtract the cell with the earlier date, from the cell withe the
later date, but add 1 to make it inclusive of the start and end dates.

=B1-A1+1
Make sure you format the cell with the formula as General.
Format>Cells>Number>General

Regards

Roger Govier

milk0s wrote:
> Hi,
>
> I am trying to work out a formula to covert rolling dates to number of days
> into a seperate row in EXCEL to save me manually working out the number of
> days between reults to make a comparison between two sets of data starting at
> different points in the year but running for a similar number of days.
>
> e.g.
> Data Set 1
> 01/01/05=day 1
> 07/01/05=day7
> 01/02/05=day32
> etc.
>
> Data Set 2
> 17/04/05=day1
> 21/04/05=day4
> 27/04/05=day10
> etc.
>
> If anyone can help me on this one I would be most grateful
>
> Thx
>
>

#3
September 28th 05, 01:31 PM
 Lenny external usenet poster Posts: n/a

=DATEDIF(Start date, End Date, "D")

you would use "Y" for years and "M" for months

Lenny

 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 Number of Days in a Date Range tesouthworthjr Excel Discussion (Misc queries) 6 July 14th 05 09:45 PM calculating number of days (e.g., Mondays) between two dates girlfriend in school Excel Worksheet Functions 10 July 14th 05 07:21 PM can excel convert number into words (like 10 to ten)? nivedrajesh Excel Worksheet Functions 2 July 11th 05 01:06 PM how do I calculate the days between dates? stucklady! Excel Discussion (Misc queries) 7 February 12th 05 04:39 PM Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM

All times are GMT +1. The time now is 07:10 AM.

 - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top