How to add day automatically after giving the date

Closed
maaiz
Posts
2
Registration date
Tuesday April 23, 2013
Status
Member
Last seen
April 24, 2013
- Apr 23, 2013 at 07:24 AM
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
- Apr 29, 2013 at 01:18 AM
Hello,

Please tell me the formula that i want that days are automatic displayed when enter any specifica date.

For example if i write in excel 23/04/2013 so along with how Tuesday will display? that can i get the formula that its display like if i wrire 23/04/2013 so in the A1 so in the A2 the day " Tuesday" display ?

6 replies

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
Apr 23, 2013 at 10:56 AM
Hi Maaiz,

In addition to Patnaik's formula, if you want to start with an upper case letter use this formula:
=UPPER(LEFT(TEXT(A1,"dddd"),1))&RIGHT(TEXT(A1,"dddd"),LEN(TEXT(A1,"dddd"))-1)

Best regards,
Trowa
1
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Apr 23, 2013 at 09:37 AM
@Maaiz

Hi

Try This, say your date in A1 Column as 23/04/2013 and write the formula in

A2 as =TEXT(A1,"DDDD")

Hope it will solve your problem other wise please inform us

Thanks

Patnaik
0
maaiz
Posts
2
Registration date
Tuesday April 23, 2013
Status
Member
Last seen
April 24, 2013

Apr 24, 2013 at 06:28 AM
Hi,

Thanks for your messages. I try to put the formula given by Patnaik & Trowa but it didnt work when i write the date 23/04/2013 in A1 Column as after putting the formula of ( A2 as =TEXT(A1,"DDDD") it should be display the Day Tuesday but it again display the A1 figure 23/04/2013 as i need to display the Day " tuesday "

Please solve the issue

Thanks
0
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
Apr 25, 2013 at 11:02 AM
Hi Maaiz,

Very strange, maybe Patnaik has some wisdom to share.

Otherwise you could upload your file for us to look at, but it is probably a "settings" problem which is specific to your pc. But we can try, right?

Use www.speedyshare.com to upload your file. Always be carefull with personal info.

Best regards,
Trowa
0

Didn't find the answer you are looking for?

Ask a question
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Apr 26, 2013 at 04:52 AM
Hi

There are several reasons

1. In A1 figure is not in date format may be it is in General or text format

2. May be Your system setings is MM/DD/YYYY and you put the figure in A1 as DD/MM/YYYY

So please check the settigs nd inform us


Thanks

Patnaik
0
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Apr 29, 2013 at 01:18 AM
Hi

Waiting for your response

Patnaik
0