Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet
I would like to be able to show number of days in seperate columns. Using
dates as values. e.g. column 1= # of days between 1 & 31, column 2= # 0f days between 1 & 60. and so on! Microsoft Office Excel 2003 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet
You can use the DATEDIF function. =DATEDIF(A1,AE1,"d") This is where the two dates that you are using are located in cells A1 & AE1. The "d" tells the formula to calculate days. This includes weekends an holidays. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=496204 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet
=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$2000),--($B$2:$B$200-$A$2:$A$200<=30))
=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$20030),--($B$2:$B$200-$A$2:$A$200<=60)) etc. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "bebz" wrote in message ... I would like to be able to show number of days in seperate columns. Using dates as values. e.g. column 1= # of days between 1 & 31, column 2= # 0f days between 1 & 60. and so on! Microsoft Office Excel 2003 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet
Sorry, to count days use
=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$2000),--($B$2:$B$200-$A$2:$A$200<=30),$B $2:$B$200-$A$2:$A$200) and =SUMPRODUCT(--($B$2:$B$200-$A$2:$A$20030),--($B$2:$B$200-$A$2:$A$200<=60),$ B$2:$B$200-$A$2:$A$200) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "bebz" wrote in message ... I would like to be able to show number of days in seperate columns. Using dates as values. e.g. column 1= # of days between 1 & 31, column 2= # 0f days between 1 & 60. and so on! Microsoft Office Excel 2003 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet
Steve G,
This formula woked for the columns and cells that I already had "True". I have 7 columns; <30, 31-60, 61-90 and so on! I need each column to show how many days a capa is open? I hope this explains what I want. Bebz "bebz" wrote: I would like to be able to show number of days in seperate columns. Using dates as values. e.g. column 1= # of days between 1 & 31, column 2= # 0f days between 1 & 60. and so on! Microsoft Office Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Importing an Excel spreadsheet from the web. | Excel Discussion (Misc queries) | |||
Delay to startup excel spreadsheet | Excel Worksheet Functions | |||
copy and paste excel spreadsheet into autocad | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |