Calculate Date through today

[MCosca]

I am trying to calculate the days from a specific start date where the end date measured could be blank, but eventually will be populated.

For example I need to be able to know the amount of days an item is still outstanding until the received date is populated.

Start date = Column N
Received Date = Column O
Result = Column Q

If the start date in Column N remains blank I would like the result in Column Q to also remain blank.
If there is a start date in Column N but not received date in Column O, I would like Column Q to calculate the days between N and Today, with the result in Column Q.
When the received date in "O" is populated, calculate the days between N & O in Q.

I currently have =IF(AND(N2<>"",O2=""),TODAY()-DAY(TODAY()),O2)-N2

N = 6/28/23
O = blank
Q = 2 days - clearly not correct as it should read 30 from 6/28 to today

When I populate o with 7/28/23, Q gives me 30, which is correct.

What did I do wrong?
Appreciate any assistance

 

[Joe4]

Try this:

=IF(N2="","",IF(O2="",TODAY()-N2,O2-N2))

 

[MCosca]

Try this:

=IF(N2="","",IF(O2="",TODAY()-N2,O2-N2))

Thank you!

 

[Joe4]

You are welcome.
Glad I was able to help.