How to add day automatically after giving the date

[Closed]
Report
Posts
2
Registration date
Tuesday April 23, 2013
Status
Member
Last seen
April 24, 2013
-
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
-
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

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
486
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
@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
Posts
2
Registration date
Tuesday April 23, 2013
Status
Member
Last seen
April 24, 2013

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
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
486
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
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
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
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Hi

Waiting for your response

Patnaik