I have 3 colums. Sent, Received and #. Sent and Received are formatted as dates. I'll call them C5,C6,C7 respectively.
What I want to do is:
If C5 and C6 are blank, leave C7 blank
If C5 has a date but C6 does not enter 0 in C7
If C5 and C6 have dates enter the difference in days between them in C7
This way if things are sent but not received the record can easily be found by looking for 0, and when things are sent and received the difference can be seen.
Is this possible?
Thank you.
Bookmarks