Two Formulas for one Cell?

B

Brandon

I am trying to execute the following formula for dates of sent/received files
and I am also showing elapsed days since the files were sent.

=IF(C1="",0,(TODAY()-B1))

This works fine if I have sent the file, it keeps count of the elapsed days
since the file was sent. However, once I receive the file back, I put that
date in, and I need this formula to then =C1-B1, which will give a total of
elapsed days. I have tried to figure this out, but for the life of me, can't
get anything to work. Any suggestions?
 
G

Gaurav

=IF(C1="",(TODAY()-B1),C1-B1)

with 'date sent' in B1 and 'date received' in C1.

does that help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Formula for elapsed time 3
Triggering a Flag after 10 days that excludes weekends and holiday 3
Show value from one cell in another cell if today falls between a date range 5
Synchronization problems while moving folders to new email 1
Mail Merge skipping records/sending one at a time 0
Aging formula with unknown dates 5
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top