| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
auto date insert
bry25_uk wrote:
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"... |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
auto date insert
hi, its microsfot works suite 2000 , spreadsheet
bryan "Gordon" wrote: bry25_uk wrote: 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"... |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
auto date insert
bry25_uk wrote:
hi, its microsfot works suite 2000 , spreadsheet bryan "Gordon" wrote: bry25_uk wrote: 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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
auto date insert
ok, thanks. couldn't find it thats why i posted here.
"Gordon" wrote: bry25_uk wrote: hi, its microsfot works suite 2000 , spreadsheet bryan "Gordon" wrote: bry25_uk wrote: 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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
auto date insert
Try
=IF(DAY(NOW())=6,NOW()-1,NOW()) Format as date "bry25_uk" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i auto insert a date and time stamp | Excel Discussion (Misc queries) | |||
| Auto insert Date & Time when another cell is populated | Excel Discussion (Misc queries) | |||
| Auto insert date/time | Excel Worksheet Functions | |||
| How do I insert an Auto Date in Excel | Excel Discussion (Misc queries) | |||
| Auto-Insert Last Date Edited | Excel Worksheet Functions | |||
Hybrid Mode
