Star Gazr1
asked on
Excel DateDif
I am using DateDif in Excel and getting an error, #NUM!
See Attached file.
I know it is because the date in Cell B1 occurs before the date in Cell A1. However I have a long list of dates I need to calculate, is there a way to fix the formula so I don't have to rearrange the Column order? Thanks for any help.
See Attached file.
I know it is because the date in Cell B1 occurs before the date in Cell A1. However I have a long list of dates I need to calculate, is there a way to fix the formula so I don't have to rearrange the Column order? Thanks for any help.
ASKER
Michael74,
Thanks for your reply. Sorry I didn't upload the file correctly. I am going to attempt the file again.
When I tried your formula, I got an error with missing parenthesis, when I added another I still am getting an error.
DateDif.xls
Thanks for your reply. Sorry I didn't upload the file correctly. I am going to attempt the file again.
When I tried your formula, I got an error with missing parenthesis, when I added another I still am getting an error.
DateDif.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That works, thanks so much for the fast solution.
https://support.office.com/en-nz/article/IFERROR-function-c526fd07-caeb-47b8-8bb6-63f3e417f611
For example
Open in new window