Forum

Notifications
Clear all

Error with formula for start date and end date

3 Posts
2 Users
0 Reactions
99 Views
(@vergildantes02)
Posts: 2
New Member
Topic starter
 

error1.jpgerror2.PNGHello. I am currently going through the tutorial "Interactive Excel Project Management Dashboard". But I am having trouble calculating my end date. I tried following the formula(s)

=WORKDAY.INTL([@[Start Date]]-1,[@Duration],1) and

=WORKDAY.INTL(Data!$D2-1,Data!$E2,1)

 

but it keeps giving me errors like 

#NUM

Excel Dashboard Date Error 1

 or 

Excel Dashboard Date Error 2

 

What am I doing wrong with the formula(s)?

 
Posted : 06/03/2022 6:29 am
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

Hello,

The column header Duration most likely interferes with the Excel function Duration, just rename the header.

Br,
Anders

 
Posted : 07/03/2022 3:12 am
(@vergildantes02)
Posts: 2
New Member
Topic starter
 

Thank you

 
Posted : 08/03/2022 6:36 am
Share: