Solved How to add days of the week automatically (POST 1)

June 2, 2015 at 03:04:48
Specs: Windows 7
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.


See More: How to add days of the week automatically (POST 1)

Report •


✔ Best Answer
June 2, 2015 at 08:55:10
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



#1
June 2, 2015 at 03:18:57
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

http://www.skeptic.com/


Report •

#2
June 2, 2015 at 03:52:10
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...



Report •

#3
June 2, 2015 at 08:50:30
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 will usually convert 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

http://www.skeptic.com/

message edited by mmcconaghy


Report •

Related Solutions

#4
June 2, 2015 at 08:55:10
✔ 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


Report •

Ask Question