Hi to your description, I modify my formula like this. I do not know how to create the measurse of the days difference. Then I want to create a chart to count number of jobs in each month which is more than 100 days. In Oct 2021, J-777 is closed and the days difference should be calculated from to which is 226 days. In Sep 2021, the job is not closed and the days difference should be calculated from to which is 208 days. ![]() ![]() Second, go to the Prodigy website and create an account. Here are the steps on how to get a free Prodigy membership: First, you need to have a computer with an internet connection. Hi, I have below data (Table 1) and I want to count the job which open more than 100 days based on the calendar month.įor Job# = J-111, in Oct 2021, the days diff between the last day of Oct 2021 () and the Created Date is 102 days.įor J-777, there is a closed date. Get a Free Prodigy Membership Without Money in 2021 is pretty easy if you follow some simple steps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |