Forum Discussion

Chan_Tze_Leong's avatar
Chan_Tze_Leong
Brass Contributor
Mar 16, 2021

Excel formula depend on date

I am an Excel file stored in MS Teams for updating by others. If they don't key in actual results by 15th day of every month, 12 midnight, the calculation should show 0, otherwise the formula using the keyyed in data will calculate. How do you formulised such a calculation in Excel that dependent on present date and timestamp?  

BI & Data Analysis
excel
Formulas and Functions

1 Reply

  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Mar 16, 2021

    Hi Chan_Tze_Leong 

    You can achieve this by using Now() function but it will provide desired result only when Calculation Option is set as "Manual". 

     

    As mentioned in below image, whenever any data is entered in coloumn C, date & time stamp is updated in column D but again it will work only with manual calculation because now() functions gives the latest date & time and if calculation option is turned as "Automatic" for each row it will show the same latest date & time.

    Note: Please use Table option to store data rather than regular cells so that your formula will be automatically for each new row added.

    Hope it will help

     

    Thanks

    Tauqeer

Resources