# Import With Dynamic Due Dates **URL:** \ **Category:** Ask the Community\ **Created:** [10 July 2018 15:21 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870 "2018-07-10T15:21:33Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![James\_Carl](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/james_carl/32/904_2.png) [@James\_Carl](https://forum.asana.com/u/James_Carl)\ **Post date:** [10 July 2018 15:21 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/1 "2018-07-10T15:21:33Z")
As I mentioned before, it is possible to use Excel to create the missing feature of dynamic due dates for new projects. It can be done with simple math or better yet a decision to only include workdays. The =workday command is flexible in many ways and also can have a lookup holiday schedule table that you could put on another tab. Attached is an example with the logic to use the command or not. Everything feeds from the Project Start Date to the Task Start Date. If one does not have Start Dates then simply change the formula to work on Due Dates. Remember to keep both as a regular spreadsheet and CSV file for repeated use. The blue areas are your critical date inputs. Hope this helps. ![Import%20With%20Dynamic%20Dates](https://us1.discourse-cdn.com/asana/original/3X/c/9/c9a1019e39288f93e39b3f0db2e9856f2ed918e1.png) ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [10 July 2018 16:19 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/2 "2018-07-10T16:19:02Z")
Nice! 🍾 ---
**Author:** ![Kenneth\_Obel](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/kenneth_obel/32/24931_2.png) [@Kenneth\_Obel](https://forum.asana.com/u/Kenneth_Obel)\ **Post date:** [28 March 2019 17:16 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/3 "2019-03-28T17:16:10Z")
This is really interesting, thanks. Surprised this has not gotten more attention. I don’t know why Asana does not include this feature, but this is a nice workaround. If I am understanding correctly, instead of using a Project Template, we’d have the Template “offline” in Excel, set up the dates as we want them, and then import it? ---
**Author:** ![James\_Carl](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/james_carl/32/904_2.png) [@James\_Carl](https://forum.asana.com/u/James_Carl)\ **Post date:** [28 March 2019 18:07 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/4 "2019-03-28T18:07:06Z")
That is correct.If you want me to send you the spreadsheet, just PM me. Thanks Jim ---
**Author:** ![Sebastian\_Thalhammer](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/sebastian_thalhammer/32/97476_2.png) [@Sebastian\_Thalhammer](https://forum.asana.com/u/Sebastian_Thalhammer)\ **Post date:** [17 March 2022 19:05 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/5 "2022-03-17T19:05:19Z")
is that template still available @James_Carl ? I would be more than interested. ---
**Author:** ![Chuck\_Fitzpatrick](https://luna1.co/8d76cd.png) [@Chuck\_Fitzpatrick](https://forum.asana.com/u/Chuck_Fitzpatrick)\ **Post date:** [27 July 2022 15:48 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/6 "2022-07-27T15:48:50Z")
Has Asana come up with a native way to import relative days form a CSV into a project? My use case is that I want to set up a template by importing a csv into a project then saving it as a Template. We have many project “types” and want a template per type. The templates will have many tasks so doing this manually in the template will be undesirable. ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [28 July 2022 06:41 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/7 "2022-07-28T06:41:54Z")
If you import a CSV with actual dates, and then turn the project into a template, Asana will basically convert dates into relative dates. Makes sense? ---
**Author:** ![Chuck\_Fitzpatrick](https://luna1.co/8d76cd.png) [@Chuck\_Fitzpatrick](https://forum.asana.com/u/Chuck_Fitzpatrick)\ **Post date:** [28 July 2022 14:38 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/8 "2022-07-28T14:38:16Z")
Thank you, Bastien, but I am still having trouble. Probably just newby flubs. In my csv, I have a column “Due Date” (and tried “Due date” as well). This gets imported (into a project) as "Due Date (imported) but the actual Due Date column is not populated. When I turn that project into a template, the same column data is saved. And creating a project from that template, same thing. Any suggestions? Thanks in advance for any help you can suggest! ---
**Author:** ![Chuck\_Fitzpatrick](https://luna1.co/8d76cd.png) [@Chuck\_Fitzpatrick](https://forum.asana.com/u/Chuck_Fitzpatrick)\ **Post date:** [28 July 2022 15:09 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/9 "2022-07-28T15:09:30Z")
Making progress - I was formatting the due dates as date-time, now I am formatting the due dates as mm/dd/yy and it is importing into the project correctly from csv. Then I can make a template and it does have the relative dates. Then when I create a project from the template, it turns those relative dates into hard dates assuming the project starts on “Today” (the day of creating the project. Thanks so much for your help, and hope my experience helps the next person! ---
**Author:** ![Chuck\_Fitzpatrick](https://luna1.co/8d76cd.png) [@Chuck\_Fitzpatrick](https://forum.asana.com/u/Chuck_Fitzpatrick)\ **Post date:** [28 July 2022 16:30 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/10 "2022-07-28T16:30:18Z")
This is all working now but one more question. When I use my template to create a project, all of the relative dates are from “today” (the day I create the project from the template.) Is there a way for me to specify a different start data? Assume I create the project on 8/1/2022 but I know it won’t actually start for a month so want the start date to be 9/1/2022. Thanks in advance! ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [2 August 2022 06:19 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/11 "2022-08-02T06:19:35Z")
In the template, you should be able to click on the different date fields, and specify a “+X” value as well as a strategy (either start date or end date). Does this help? Can you share a screenshot of your template please + a screenshot of the popup when clicking on a date field? ---
**Author:** ![Jessica\_Ramirez](https://luna1.co/8d76cd.png) [@Jessica\_Ramirez](https://forum.asana.com/u/Jessica_Ramirez)\ **Post date:** [17 October 2023 19:46 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/12 "2023-10-17T19:46:42Z")
I have tried this several times but the due date isn’t importing. Any tips? ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [19 October 2023 10:17 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/13 "2023-10-19T10:17:24Z")
Can you share the file you are using? Did you check the “Make changes” to look at the mapping? ---
**Author:** ![Jessica\_Ramirez](https://luna1.co/8d76cd.png) [@Jessica\_Ramirez](https://forum.asana.com/u/Jessica_Ramirez)\ **Post date:** [23 October 2023 22:33 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/14 "2023-10-23T22:33:22Z")
I did. The Due Date part is grayed out and says it needs to be in date format but I’ve adjusted that several times and I have the same issue. ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [25 October 2023 05:30 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/15 "2023-10-25T05:30:59Z")
> [@Jessica\_Ramirez](#): > > The Due Date part is grayed out and says it needs to be in date format That’s definitely your problem. Are you using YYYY-MM-DD? Are you sure 100% of the tasks have the right format or an empty cell? Feel free to share the file in private so I can test myself. ---
**Author:** ![Larry\_Berger\_lpb](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/larry_berger_lpb/32/276017_2.png) [@Larry\_Berger\_lpb](https://forum.asana.com/u/Larry_Berger_lpb)\ **Post date:** [25 October 2023 17:33 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/16 "2023-10-25T17:33:20Z")
@Jessica_Ramirez, When I run into things like this, I try to import a CSV with a single row in it to simplify the process. Perhaps that could help you along the way here. Thanks, Larry ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [2 November 2023 08:03 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/17 "2023-11-02T08:03:41Z")
I looked at your file and this is a typical error: one line has a faulty date. If you click on “Make changes”, and try to select “Due date” is says exactly what’s wrong: row 238 says “Ongoing” instead of a date. ![CleanShot 2023-11-02 at 09.02.07@2x](https://us1.discourse-cdn.com/asana/original/3X/8/d/8d55936fb03aa01e414eda9eb808c1288e5f5dfe.png) ---
**Author:** ![Jessica\_Ramirez](https://luna1.co/8d76cd.png) [@Jessica\_Ramirez](https://forum.asana.com/u/Jessica_Ramirez)\ **Post date:** [6 November 2023 20:04 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/18 "2023-11-06T20:04:32Z")
Thank you so much! This information was so helpful! ---
**Author:** ![Trelynda\_Kerr](https://luna1.co/8d76cd.png) [@Trelynda\_Kerr](https://forum.asana.com/u/Trelynda_Kerr)\ **Post date:** [10 April 2024 20:52 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/19 "2024-04-10T20:52:18Z")
Hi James, would it be possible to send you my excel schedule I have to see how it could be imported? It is a production schedule and the entire schedule is driven by the mail date and counts days back. ---
**Author:** ![Phil\_Seeman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/phil_seeman/32/81525_2.png) [@Phil\_Seeman](https://forum.asana.com/u/Phil_Seeman)\ **Post date:** [11 April 2024 18:44 UTC](https://forum.asana.com/t/import-with-dynamic-due-dates/25870/20 "2024-04-11T18:44:36Z")
@Trelynda_Kerr, Just FYI, that post is from 5 years ago and I haven’t seen @James_Carl around the forum in the past 2 or so years. [Next page](https://forum.asana.com/t/import-with-dynamic-due-dates/25870.md?page=2)