 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008auto date insert
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 > 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"... hi, its microsfot works suite 2000 , spreadsheet bryan > > 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"... > hi, its microsfot works suite 2000 , spreadsheet > bryan > >>> 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"... then I suggest you re-post to microsoft.public.works.win ok, thanks. couldn't find it thats why i posted here. > > hi, its microsfot works suite 2000 , spreadsheet > > bryan [quoted text clipped - 4 lines] > > then I suggest you re-post to microsoft.public.works.win Try =IF(DAY(NOW())=6,NOW()-1,NOW()) Format as date > 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, [quoted text clipped - 4 lines] > thanks > bryan
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.