Hi... i needed a help with this quesry

Is there a way where i can keeping adding days one after the other automatically.

I am not sure how to put it in words.What i meant is :

Suppose the first column is a Sunday ... the second column we put a formula which gives me Monday and so on.

And if i change the first column to Tuesday it should automatically change the next column to Wednesday.Please let me know if this is not clear.

A help will really be appreciated.

✔ Best Answer

I provided a possible solution in this thread: http://www.computing.net/answers/of...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

You failed to mention what program this concerns, so I'll take a guess that you mean Excel. With your Start Date in cell A1

in cell B1 you would enter the formula: =A1+1

then simply drag across as many columns as needed.

This should get you what your looking for.Also, Excel questions are best asked in the Office Software Forum.

MIKE

Hello ..Thank you so much for the reply. My wrong i should have mentioned excel. I tried the same... but doesnt work. May be coz its text.

I am sorry to be posting on this forum .. i thot i was posting in the office software forum...

May be coz its text.The formula will not work on TEXT, you will have to convert the text string date

into a real date.How is your date written?

You can use the =DATEVALUE() function

and it willusuallyconvert a text value

that looks like a Date into a real Date.With your Text Date in cell A1

in cell B1 you would enter the formula: =DATEVALUE(A1)See how that works.

EDIT ADDED

If you end up with a 5 digit number,

reformat the cell to a Date Format.MIKE

message edited by mmcconaghy

I provided a possible solution in this thread: http://www.computing.net/answers/of...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History