I have a spread sheet in which I track approximately 165 boxes that go out to customers daily.
I track them by account number and then customer name. I would now like to try to come up with a formula that would automatically set the date when I change the account number in B3 and the account name in C3 on the same day. I would then like to show in another cell the number of days a box has sat at the account.
I think I have the correct formula for tracking how many days =DATEDIF(E3,F3,"G"). (cell E3 should be equal to the day changed, F3 is =TODAY()) which should give me the days it has sat, but I am completely at a loss on how to formulate cell E3 to show the date I changed cells B3 & C3.
See example below.
BOX3 ACCT# ACCOUNT NAME DAY CHANGED TODAY'S DATE BOX DAYS
1 EXMP1 EXAMPLE 1 03/04/2013 #VALUE!
2 EXMP2 EXAMPLE 2
3 EXMP3 EXAMPLE 3
4 EXMP4 EXAMPLE 4
Thank you!