Help in Excel Date Calculation

[Anas_Ejaaz]

Hello All

 I'm working as a professional inventory planner in one of FMCG companies in Pakistan.  I'm stuck with one formula in which i have to calculate the date Manually. 

Scenario: 

Like i have to check where my inhand inventory will finish then i will enter manually1 day before finishing my stock in the date column. Is there any formula to calculate automatically? Thanks in advance 

Anas Ejaaz

email address removed for privacy reasons

[#2]

@Anas_Ejaaz 

How should the date be calculated?

[#3]

@Hans Vogelaar 

I did manually.. i go back in my chart and see where the inventory will go low. Then less one day from there to backward 

[#4]

@Anas_Ejaaz 

I'm afraid that's too vague.

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.