Forum Discussion
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 t...
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