ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   tomorrow's date on an invoice made today (https://www.excelbanter.com/new-users-excel/207847-tomorrows-date-invoice-made-today.html)

Carlos

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

ShaneDevenshire

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


Ron@Buy

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



All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com