Forum Discussion

Anas_Ejaaz's avatar
Anas_Ejaaz
Copper Contributor
Oct 03, 2022

Help in Excel Date Calculation

 

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

excel
Formulas and Functions

3 Replies

    • Anas_Ejaaz's avatar
      Anas_Ejaaz
      Copper Contributor
      Oct 04, 2022

      HansVogelaar 

      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 

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Oct 04, 2022

        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.