User Profile
ArchibaldSM
Copper Contributor
Joined Jul 27, 2023
User Widgets
Recent Discussions
Help with excel formula Please
Hi All, Your assistance would be greatly appreciated as my brain has now melted trying to figure out what the problem could be. I have an Excel spreadsheet with multiple sheets. All of the sheets are identical the only difference is the name of the sheet. Each sheet contains the following columns: E - Planned Start Date F - Planned Duration (Days) G - Planned Completion Date - which is auto-filled using the following formula: =IF(OR(ISBLANK([@[Planned Start Date]]),ISBLANK([@[Planned Duration (Days)]])), "",[@[Planned Start Date]]+[@[Planned Duration (Days)]]*1) This works perfectly 99% of the time but sometimes returns #VALUE! All columns are formatted the same i.e. E (Date); F (Number); G (Date) I'm at a complete loss as to why this is happening and have tried everything in my knowledge to resolve it. Any assistance or guidance would be greatly appreciated. With thanks in advance.1.6KViews0likes8Comments
Recent Blog Articles
No content to show