To make the Function Static when it turns 22:30pm

Lets say i have three columns
Col A --------Col B -------Col C -------Col D --------Col E
Sr.No --------Topic-------Decription---Author--------Date
Coding –[ IF(And(ISBLANK(B2),ISBLANK(C2),ISBLANK(D2)),””, TODAY()) ]
Now if i use this fucntion then it gives me the current date if all the columns are filled and blank if vice-versa, however this would work fine but the function would always keep the date changing each day (i.e. Dynamic) if i check the file the next day as today would always show the current date ,whereas I want it to remain Same (Static).. if there are no chnages made i that row till 22:30pm (Max Time i would be in the office)
My logic is the date should remain if there has been no changes made in that row till 22:30pm the max time to stay back at work..

I s this possible..?
CAn u make it possible..?

Originally Posted by all4excel

Lets say i have three columns
Col A --------Col B -------Col C -------Col D --------Col E
Sr.No --------Topic-------Decription---Author--------Date
Coding –[ IF(And(ISBLANK(B2),ISBLANK(C2),ISBLANK(D2)),””, TODAY()) ]
Now if i use this fucntion then it gives me the current date if all the columns are filled and blank if vice-versa, however this would work fine but the function would always keep the date changing each day (i.e. Dynamic) if i check the file the next day as today would always show the current date ,whereas I want it to remain Same (Static).. if there are no chnages made i that row till 22:30pm (Max Time i would be in the office)
My logic is the date should remain if there has been no changes made in that row till 22:30pm the max time to stay back at work..

I s this possible..?
CAn u make it possible..?

Please i need this code guys..