I need a date formula in ms excel?

I need a date formula in excel. If I entered date 1/12/07 in A1, then in A2 date 2/12/07 need to enter automatically and so on up to for 1 month. But date must appear in sheet only when next day begin (If today date is 19/12/07, then 20/12/07 must appear tomorrow only).

I need a date formula in ms excel?
Cell A1 formula: "=today()" without quotes





Cell A2 formula:


=IF(A1="","",IF(MONTH(DATE(


YEAR(A1),MONTH(A1),DAY(A1)


+1))=MONTH(A1),IF(YEAR(DATE


(YEAR(A1),MONTH(A1),DAY(A1)


+1))=YEAR(A1),A1+1,""),""))





all one long formula





Copy A2 and Paste Special FOrmula from A3 through to Cells A31


Copy Cell A1 and Paste Special Formats from A2 through A31
Reply:when we enter date into our worksheet,such as June 15,2001 , Excel stores that data as serial number .serial numbers represent starting points that are programmed into Excel . A date serial number is computed from the starting point of December 31,1899.


If we enter the date December 31,1993,for example , the serial number is 34,334.this means that 34,334 days have passed between december 31,1899 , and december 31,1993.
Reply:cell A1: 19/20/07


cell A2: =A1+1 (copy down this up to cell A15)





click on cell A1, go to Format menu | Conditional Formatting


Formula Is: =A1%26gt;TODAY()


Format %26gt; Font %26gt; Color %26gt; set to White color %26gt; click ok.


Click ok again to close Conditional Formatting dialog box.





cell A1 %26gt; Edit menu | Copy


select cell A2:A15 %26gt; Paste Special %26gt; Format %26gt; ok





Good luck.