Previous Topic Next Topic

How to add day automatically after giving the date

Closed
maaiz Posts 2 Registration date Tuesday 23 April 2013 Status Member Last seen 24 April 2013 - 23 Apr 2013 à 07:24
sgmpatnaik Posts 52 Registration date Tuesday 2 April 2013 Status Member Last seen 27 November 2013 - 29 Apr 2013 à 01:18
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

Réponse 1 / 6
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
23 Apr 2013 à 10:56
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
Réponse 2 / 6
sgmpatnaik Posts 52 Registration date Tuesday 2 April 2013 Status Member Last seen 27 November 2013 45
23 Apr 2013 à 09:37
@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
Réponse 3 / 6
maaiz Posts 2 Registration date Tuesday 23 April 2013 Status Member Last seen 24 April 2013
24 Apr 2013 à 06:28
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
Réponse 4 / 6
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
25 Apr 2013 à 11:02
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
Réponse 5 / 6
sgmpatnaik Posts 52 Registration date Tuesday 2 April 2013 Status Member Last seen 27 November 2013 45
26 Apr 2013 à 04:52
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
Réponse 6 / 6
sgmpatnaik Posts 52 Registration date Tuesday 2 April 2013 Status Member Last seen 27 November 2013 45
29 Apr 2013 à 01:18
Hi

Waiting for your response

Patnaik

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses