Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you so very much Steve!
Yes it works great! One problem I had, however, was getting an accurate count from the very date received to the "date", so I made a very small modification to the formula: =IF(ISBLANK(H191),0,DATEDIF(G191-1,H191,"d")). ************************************** SteveG wrote: Roberta, Assuming A1= "Date", B1 = "Received Date" & C1 = "Total Days" then in C2 enter: =IF(ISBLANK(A2),0,DATEDIF(B2,A2,"d")) HTH Steve -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Maintaining a default worksheet order | Excel Discussion (Misc queries) | |||
Using PROPER for Columns, rows or ENTIRE spreadsheet | Excel Worksheet Functions | |||
Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) |