Calculate dates based on values entered or based on today’s date

I hope I don’t confuse anyone. I need to calculate dates based on values entered or based on today’s date. Column “B” will always have a date. Colum “M” will only have a date when it was corrected. In column “A” I have a formula that reads “=IF(M2<B2,””,M2-B2)” it will return the difference in days. I also have it set to conditional format and turn read if greater than 2 days. Now there will be times when a date hasn’t been entered in column M because it hasn’t been resolved. So in this case I need it to look at the date in Column “B” and look at today’s date and return that difference.

1. Column A is the formula calculates dates
2. Column B is a date
3. Column M, date when is corrected or need difference between column B date and todays date.

The formula needs to exclude weekends

Will it exclude weekends? In other words it only looks at a 5 day work week. Also how do I remove if I receive a #VALUE!. Part if the formula is working if I have a date in B and M but if "M" is blank I getting an #VALUE! error

pjwhitfield - I keep getting the #Value! on some cells. I went back and check and it turns out that some have N/A in the "M" column date. Is their away around this where it will ignore that?

newdoverman - your formula worked but it continues to calculate todays date vs what in column "B". In other word if the date in column B was 3/2/2015 and the date in column M was 3/3/2015 the results is 111 days. It should read 1 day. the only time it should read 111 if M was blank.

I appreciate the help each of you are providing.

Ok I got this to work I just need to figure out the removal of #VALUE!. The formula I use is =IF(M2="",NETWORKDAYS(B2,IF(LEN(M2)<3,TODAY(),M2)),M2-B2)

Awesome, that seems to have done the trick. Thank you for your assistance.

You are correct, I ended up using this formula =IFERROR(IF(M2="",NETWORKDAYS(B2,IF(LEN(M2)<3,TODAY(),M2)),M2-B2),""). It seems yours does the same and is cleaner so I will take that route. Here is my issue now. If B2 has no date the cell with the formula is returning a number of 30,158. I need this to remain blank until a date is entered in B2. How can I correct this?

Ok I got it to do what I wanted with my old formula by adding an if statement at the beginning =IF(B2>0,IFERROR(IF(AND(M2="",B2<>""),NETWORKDAYS(B2,IF(LEN(M2)<3,TODAY(),M2)),M2-B2),"0"),"")