Excelme at work
New Member
- Joined
- Feb 7, 2018
- Messages
- 18
Hi there, I have a schedule showing delivery information and would like to use a formula to show by how many days a delivery was either early or late.
I have previously used IF function to show if the delivered date cell is before or after the scheduled date cell.
But ideally i would like to show as either positive or negative number of days.
Is this possible?
Thanks in advance
I have previously used IF function to show if the delivered date cell is before or after the scheduled date cell.
But ideally i would like to show as either positive or negative number of days.
Is this possible?
Thanks in advance