timeline

[jasman]

Hi. I have found and tried the folowing code in which i add a date to c4 and then drag this formula along row 4. It works but it mises a column between the dates? any reason why?

=IF(MOD(COLUMN(),2)=0,"",IF(MONTH($C4+INT(COLUMN()/2))=MONTH($C4),C4+1,""))

 

[p45cal]

Since
MOD(COLUMN(),2)=0
is TRUE for alternate columns, alternate columns wil show "".

What are you trying to do?

 

[jasman]

Im basically creating a timeline in where it looks at the date entered by user in d4 and enters the next day into e4 and the rest of the cells in row 4

 

[p45cal]

in that case, in E4:
=D4+1
Enter, then drag to the right (autofill).
Make sure that the results are formatted as dates (this will probably happen automatically).

 

[jasman]

thanks for that it works ....