Excel calculation issue

New Contributor

I am trying to calculate this numbers in date format it is giving me error message #VALUE!  Please I need your help. Thanks

Start DateEnd Date
29/7/202131/7/2021
7/8/20219/8/2021
9/8/202113/8/2021
2/9/20215/9/2021
15/9/202130/10/2021
7/11/202121/11/2021
27/11/202130/11/2021
7/12/20219/12/2021
10/12/202115/12/2021
3 Replies

@optimisticlint 

Please check are these texts which looks like dates or not. Dates are actually numbers in Excel. You may test in any empty cell as =ISTEXT(A1) if in A1 is any such date.

@Sergei, thanks for your reply, I am working on my Project Management Plan (PMP) so I'm using excel to do up my schedule to enable me generate a Gantt Chart. The problem is some of the cells worked and some don't.

@optimisticlint 

Some could be texts some not and it could be at least another dozen of reasons why you have an error. Without the sample file it's hard to say what's wrong.