Hello all!
I'm working on developing an annual housing report spreadsheet and I need to have an equation in AI3 that will calculate the number of days between AG3 (move in) and AH3 (move out). If there is no move out date yet, AI3 should use the current date to calculate how many days that person has been in housing (so it will automatically recalculate each day).
Right now I have this equation entered in AI3
=DATEDIF(AG3,TODAY(),"d")
The issue is that when there is no date entered in AG3, "41662" is what appears in AI3. I need AI3 to remain at "0" until a date is put into AG3.
Does anyone know what equation I would use?
Thank you so much!
Bookmarks