View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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