| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting days comparing 2 dates excluding empty cells
I've entered the formula =(L25-M3) in a target cell to count the length of
stay of patients on a hospital unit. L 25 contains the formula to enter the current date,that is =today(). Each cell in column "M" is the hand entered admission date. This formula works but I need it to ONLY do the calculation if there is a value entered in column "M." What argument do I add to suppress the calculation if "M" is blank? Currently it displays a bizzar number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Empty Dates within a Range? | Excel Worksheet Functions | |||
| Counting number of days up to an empty cell then start over again | Excel Discussion (Misc queries) | |||
| lowest number in row excluding empty cells | Excel Discussion (Misc queries) | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| excluding cells from the formula when empty | Excel Worksheet Functions | |||
![Terry Rogers[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
