View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default Inserting dates function

try this

in cell A1 put any date
and cell A2 put this formula and drag it down

=IF(COUNTIF($A$1:A1,A1)<=2,A1,A1+1)



ArthurN wrote:

Hi,
I wanted to insert dates that would be repeated 3 times and then move to the
next day on the calendar, something like this:
02.02.09
02.02.09
02.02.09
02.03.09
02.03.09
02.03.09
Is there a function, that I would be able to drag over several rows?
Thank you in advance,
Arthur N