Formula to return number of days between two columns of Dates

[Lillianlanauze]

Formula to return number of days between two columns, the cells in the columns may have dates populated, or could be blank, or one column may populated and not the other. So of course if both are populated with dates no problem it returns a count. I need if the one column has a date but the other does not then return a count of days till today's date.

 

[andiemac]

Will there always be a start date, and may not always be an end date? This should work =IF(B1>0,B1-A1,TODAY()-A1)

If either column may have a blank date then try: =IF(AND(B1>0,A1>0),B1-A1,IF(B1=0,TODAY()-A1,IF(A1=0,TODAY()-B1,0)))

 

[Lillianlanauze]

Brilliant!! It worked thank you so much!! I wish I could buy you lunch!

 

[Mavericks334]

You could also use this

C2=IF(B2="",Networkdays(A2,Today()),networkdays(A2,B2)

This would take care of any holidays.

Also you could you use
C2=if(B2="",Days360(A2,Today()),Days360(A2,B2))