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 a...
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
- one more observation - when I look at format of the cell above (col E) it is in the UK date format, but when I look at it in the formula bar it is in the US date format
