Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello --
I have to keep track of a number of certificates and licenses. I have a sheet where I have in a column when the license was obtained and another column when the license expires. There is a third column that calculates the difference in days between the two. When the certificate expires I get an out of range error. Can I capture that error and make the cell simply say: "Expired" ? Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DATEDIF? | Excel Discussion (Misc queries) | |||
Datedif | Excel Worksheet Functions | |||
Datedif() | Excel Discussion (Misc queries) | |||
DATEDIF | Excel Worksheet Functions | |||
DateDif Average? Damn DateDif | Excel Worksheet Functions |