Using DATEDIF function with no end date (replace with today)

[lysander]

Hello

I'm using DATEDIF function to calculate number of days difference between two dates. I have a spreadsheet with many rows of data and two columns, one for the start date and one for the end date. Some rows do not have an end date. In this case I want to calculate the difference between start date and Today.

However I am struggling to NEST the DATEDIF function with the today function when there is no end date.

How can I set things up so that when there is no end date my formula understands to use Today's date?

Thanks

 

[macattackpro]

Here's a solution without DATEDIF:

=IF(A2="",TODAY(),A2)-B2

 

[lysander]

great thanks