K
kathi
I have a question I'm hoping someone can help me with. I need to know how
many days an invoice was open.
Column A2:A500 is the open date and
Column B2:B500 is closed out date. I need an
"IF B is null" added onto my original =+IF(K4<=J4,1,DAYS360(J4,K4)+1) so
that if there is a closed date then count the number of days between the open
date and close date BUT IF there isn't a close date just count the number of
days from the open date until the current date. Can anyone help?
many days an invoice was open.
Column A2:A500 is the open date and
Column B2:B500 is closed out date. I need an
"IF B is null" added onto my original =+IF(K4<=J4,1,DAYS360(J4,K4)+1) so
that if there is a closed date then count the number of days between the open
date and close date BUT IF there isn't a close date just count the number of
days from the open date until the current date. Can anyone help?