| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
tomorrow's date on an invoice made today
I'm using Microsoft Excel Invoice that calculates totales, the date will be
the same as the date when I make it and I want it to be for the next day. Also I need help in order to have automaticly a progresive invoice number. I thank you in advance |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
tomorrow's date on an invoice made today
Hi,
I do not have the file you refer to but the date is probably calculated with the TODAY() or NOW() function. Select the cell where the date is and add 1 to it, change the formula to read =TODAY()+1 If the cell is locked choose Tools, Protection, Unprotect Sheet. and try again. -- Thanks, Shane Devenshire "carlos" wrote: I'm using Microsoft Excel Invoice that calculates totales, the date will be the same as the date when I make it and I want it to be for the next day. Also I need help in order to have automaticly a progresive invoice number. I thank you in advance |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
tomorrow's date on an invoice made today
Carlos
Assistance with progressive invoice number may be found he http://www.mcgimpsey.com/excel/udfs/sequentialnums.html "ShaneDevenshire" wrote: Hi, I do not have the file you refer to but the date is probably calculated with the TODAY() or NOW() function. Select the cell where the date is and add 1 to it, change the formula to read =TODAY()+1 If the cell is locked choose Tools, Protection, Unprotect Sheet. and try again. -- Thanks, Shane Devenshire "carlos" wrote: I'm using Microsoft Excel Invoice that calculates totales, the date will be the same as the date when I make it and I want it to be for the next day. Also I need help in order to have automaticly a progresive invoice number. I thank you in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to return tomorrow's date. | New Users to Excel | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
Linear Mode
