Mar 16 2021 03:17 AM - edited Mar 16 2021 03:22 AM
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?
Mar 16 2021 11:50 AM
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