Previous Topic Next Topic

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 52 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 ?
Related:

6 responses

Answer 1 / 6
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
Answer 2 / 6
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
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
Answer 3 / 6
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
Answer 4 / 6
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
Answer 5 / 6
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
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
Answer 6 / 6
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
Apr 29, 2013 at 01:18 AM
Hi

Waiting for your response

Patnaik
0