Forum Discussion

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
5 years ago

Days computation

Hi,    So.. I am stuck again. ðŸ˜¥   I have this data: MATERIALOFFLOADING DATELOADING DATE MAT1 05/01/2021   MAT1   20/03/2021 MAT2 05/01/2021   MAT2  ...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi mussaenda , 

Could you    pls provide the formula for the number of days? 

Mat1  28 day in Janaury， how to use the following to calculate it? 

MATERIALOFFLOADING DATELOADING DATE

MAT1 05/01/2021  
MAT1   20/03/2021

 

 

Best Regards

Lucien

 

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    5 years ago

     

    Sorry v-luwang-msft ,

     

    That should be 26 days.  (The Feb must be 28.)

    Days between 05/01/2021 and 31/01/2021 = 26 for month of January. (Or I think it should be 27?)

    Days between 01/02/2021 and 28/02/2021 = 28 for month of February.