Count between dates excluding blanks

[louisanolan]

Hi all,

I have looked through so many threads on here and I can't find the answer to my question so I'm hoping someone can help with a formula.


I have a spreadsheet with the date something started (B3) and then with the date something ended (AM3) - I have a formula which counts the number of days it has been between the date it started and today's date, unless there is something in the end date and then to count between those dates (if that makes sense?!) which does that:

=IF(AM3>0,AM3-B3,TODAY()-B3)

However I need to add in 'Don't bring back anything if B3 (Date something started) is blank' into it and I can't for the life of me work out how to add that in....

Can anyone help at all?

Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(B3="","",IF(AM3>0,AM3-B3,TODAY()-B3))

 

[louisanolan]

That is brilliant - works perfectly! Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.