Adding a Today's date to a Calendar Day formula

[searchingforhelp]

Hi,
I am trying to create a formula in column C to do two things.
1. Calculate calendar days between B and A.
2. If a date is not listed in column B, have the formula in column C calculate from the date whenever the sheet is opened.

Practice Sheet.xlsx
	A	B	C
1	Date Assigned	Date Reviewed	Calendar Days
2	7/1/2020	7/2/2020	1
3	7/1/2020		-44013
4	7/1/2020	7/2/2020	1
5	7/1/2020	7/2/2020	1
6	7/1/2020		-44013
Test

Cell Formulas
Range	Formula
C2:C6	C2	=B2-A2

 

[Fluff]

How about

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

 

[Nlhicks]

=today()-A3

 

[Nlhicks]

You need to change the number format to general and it should work

 

[searchingforhelp]

Thank you Fluff and Nlhicks. My apologies for the late response.

 

[Fluff]

Glad we could help & thanks for the feedback.