TADA!! It works!
Thank you so much, Chuck
That was a very fast reply. Wow
Tonya
CLR wrote:
Hi Tonya..........
Wrap your formula in an IF statement, like
=IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1))
Vaya con Dios,
Chuck, CABGx3
"Tonya Marshall" wrote in message
...
I am very new to Excel and having to learn everything from a blank slate.
My friend gave me the following formula to calculate days of stay and it
works well except I would like to have something in the formula that if
the result is zero, then make it 1.
=DAYS360(A1,V1)
Thank you.
|