Track the work on today date value

[akshay6s]

HI everyone,


i have a file in which i have to track clients. i need to take follow ups of them on the given dates in column regarding the work of column F.
my requirement is that in column E(today follow up) should be shown automatically according to column i.

for example:-cell f10 has to be done on date i10. so i want that the value of i10 (8-3-2019) should be shown in e10(8-3-2019) automatically and so on for every work.

hoping that this will also be solved as before. so thanks in advance.

[Phuocam]

Try this in E3:

=IF(TODAY()=I3,I3,"")

[akshay6s]

THANKS for replying on my query. but this is not working.

[avk]

Also you do this in "E3"

Please Login or Register  to view this content.

copy paste down.
in this case no need to change column in formula.
see attach file. [row 10 for example]

[avk]

for post #3 : Date issue actually date is 3 Aug 2019

[akshay6s]

yes you are right. i have correct that. both of the answers are working.