find days since order date
Posted on 2013-12-11
In column A3 I have the date the part was asked for. In G3, I have a column for days since date was asked for. In E3, I have date part received.
So if E3 has a value I need G3 to say received or something like that. If E3 is blank then I need (current date - A3 date) to go in G3 (number of days).
What would this formula look like?