Forum Discussion
Working days date count
Hello EmilyM2019
first of all please copy my first code to a new blank query and name the query fnNetWorkDays2
then change your code as follows
= Table.AddColumn(#"Changed Type1", "Working days count", each fnNetWorkDays2([#"Changed On (Task)"], DateTime.FixedLocalNow()))
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi Jimmy801
When I copy and paste your code into a new blank query it doesn't load in as an fx query, it shows as ABC and all the text is in red.
What am I doing wrong?
Thanks, Emily.
Hello EmilyM2019
most probably you are copying into the formula bar.
Open the advanced editor, delete everything and paste my first code
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy