AC66Bronco Posted August 28, 2012 Report Share Posted August 28, 2012 Ok I am trying to find the total number of days between a range of days. The issue is the start date in some cases will be blank due to the nature of things. - 07/30/12 07/30/12 - - - - - - - 08/01/12 - - - - - - - 07/17/12 07/19/12 07/19/12 - - - - 07/26/12 07/26/12 - 07/10/12 - - - - - - - - 07/11/12 07/11/12 - - - - 07/23/12 - - - - - - - - 07/31/12 - the data looks like that. so for line 1 the answer I would like retrieved would be 1 line2 to the value I need would be 1 3 would be 9 etc etc. anyone got any ideas? the - indicates cells where no date is entered due to that loan not having that type of transaction occurring. Quote Link to comment Share on other sites More sharing options...
unfunnyryan Posted August 28, 2012 Report Share Posted August 28, 2012 =DAYS360(A1,A2,FALSE) A1 being location of start date, A2 the end date. However, it'll mark 0 for your first line going from 7/30/12 to 7/30/12. You can fix this by using an IF statement beforehand. =IF(A1=A2,1,DAYS360(A1,A2,FALSE)) Quote Link to comment Share on other sites More sharing options...
AC66Bronco Posted August 28, 2012 Author Report Share Posted August 28, 2012 will give it a shot momentarily ty Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.