Forum Discussion
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.
8 Replies
That could be if Planned Start Date is entered as text, not as actual date. You may check in any empty cell in the same row as
=ISTEXT(Table[@[Planned Start Date]])- Hi Sergei,
Many thanks for your response. When I enter the formula above it returns the value TRUE - not exactly sure what this implies- When I complete for the working cells in col G it returns FALSE. I have double and triple checked that the date in col E is formatted to DATE
