Current Date Comparison / Cell Range Retrival

[arshadmohamed]

Hiiiii

I have some data entered in a Excel like this..

Each time i open this work book i want the current system date datas to be appearing in some particular cell like in "H6, H7, H8 & H9"

issit possible to compare and check for current system dates?

If so how will i make the assigned time data's appear in some plc in the sheet?

Date Time-1 Time-2 Time-3

01-01-05 10:01 23:06 8:15
02-01-05 11:01 0:06 9:15
03-01-05 12:01 1:06 10:15
04-01-05 13:01 2:06 11:15
05-01-05 14:01 3:06 12:15
06-01-05 15:01 4:06 13:15
07-01-05 16:01 5:06 14:15
08-01-05 17:01 6:06 15:15

 

[arshadmohamed]

WoWeeeeeee

It worked Sir

ThanQ soo much