Hi It will be great if anyone could help me with this!
Suppose the file name is 'AA 26 Mar 02'
In Cell A1 (say) I have text 'BB 26 Mar 02'
If I save the file with new name to 'AA 27 Mar 02' how can Cell A1(say) change to 'BB 27 Mar 02' such that whenever I change the date within the filename will automatically change the date in Cell A1.
Thanks every one!!
Looking for your quick reply
Suppose the file name is 'AA 26 Mar 02'
In Cell A1 (say) I have text 'BB 26 Mar 02'
If I save the file with new name to 'AA 27 Mar 02' how can Cell A1(say) change to 'BB 27 Mar 02' such that whenever I change the date within the filename will automatically change the date in Cell A1.
Thanks every one!!
Looking for your quick reply