auto date insert

[bry25_uk]

i'm using office spreadsheet which is similar formulas to excel i believe. I
want it to automatically insert a date when you open it on a certain day,
i.e., if i open my file on a friday, i want it to automatically enter the
date and possibly cell data into the corresponding columns. ever friday i
have a debit and i would like this to appear on it's own. if i were to open
on a Saturday, can it auto enter for the previous day???
thanks
bryan

 

[Gordon]

i'm using office spreadsheet which is similar formulas to excel i believe.

Well either you are using Excel or you aren't.....what do you mean by
"Office Spreadsheet"...

 

[bry25_uk]

hi, its microsfot works suite 2000 , spreadsheet
bryan

 

[Gordon]

hi, its microsfot works suite 2000 , spreadsheet
bryan

then I suggest you re-post to microsoft.public.works.win

 

[bry25_uk]

ok, thanks. couldn't find it thats why i posted here.

 

[Billy Liddel]

Try
=IF(DAY(NOW())=6,NOW()-1,NOW())

Format as date