Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using execl 2000. In my spreadsheet I have to calculate how many days it
takes to send out requests from receiveing them. I have set up a formula which takesaway the date the request was sent out from the data the request was received. So if the dates in the requests field received and requests field sent are the same it will show 0, if the dates are different by 1 day it will show as 1 etc. Is their any way that I can enter text into the formula so that it will put day in Eg: 0 Day, 1 Day, 2 Day etc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula to strip figures from cells text strings | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula for adding a comma in front of text in a cell | Excel Worksheet Functions |