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
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 ?
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:
- How to add day automatically after giving the date
- How to add songs to sound picker - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
- Download automatically while roaming - Guide
- How to add photo in word resume - Guide
6 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 23, 2013 at 10:56 AM
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
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
sgmpatnaik
Posts
52
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
45
Apr 23, 2013 at 09:37 AM
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
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
maaiz
Posts
2
Registration date
Tuesday April 23, 2013
Status
Member
Last seen
April 24, 2013
Apr 24, 2013 at 06:28 AM
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
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 25, 2013 at 11:02 AM
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
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
sgmpatnaik
Posts
52
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
45
Apr 26, 2013 at 04:52 AM
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
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
sgmpatnaik
Posts
52
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
45
Apr 29, 2013 at 01:18 AM
Apr 29, 2013 at 01:18 AM
Hi
Waiting for your response
Patnaik
Waiting for your response
Patnaik
