Count # of days between status change and due date

[Ryan_Murphy1]

I use airtable for marketing project management of creative requests. I would like to count the timelines that my team is given. I want to count the number of days from the moment a record status is changed to "Ready for design" to said record's due date. I have a DATETIMEDIFF from date created to date due, but that is no longer working for our team. TIA

[Sho]

Hi, @Ryan_Murphy1 

Is this correct?

IF({Status}="Ready for design",DATETIME_DIFF({End Date},NOW(),"days")+1)

[Ryan_Murphy1]

Hmm. I got that to work (as in no errors) but it returned a blank cell!

[Sho]

{Status}, "Ready for design" and {End Date} need to be modified to match the fields in your table to work