G
Guest
I've used the networkdays function to return the number of business days
between the current date and the date a check was cut. Based on the number of
days I than want information inputted into a third cell which states the
range the check falls into. In this example the ranges are 0-5 days, 6-10
days, 10-30 days, 30-60 days, 60-90 days and 90+ days. I'm basically trying
to show the aging of the checks. I have been able to use if statements to get
each one to work individually but for some reason when I combine them I get
the right result if the check is 5 days or younger but get a false after
that. Anybody have any ideas as to how I can resolve?
Thanks
between the current date and the date a check was cut. Based on the number of
days I than want information inputted into a third cell which states the
range the check falls into. In this example the ranges are 0-5 days, 6-10
days, 10-30 days, 30-60 days, 60-90 days and 90+ days. I'm basically trying
to show the aging of the checks. I have been able to use if statements to get
each one to work individually but for some reason when I combine them I get
the right result if the check is 5 days or younger but get a false after
that. Anybody have any ideas as to how I can resolve?
Thanks