Excel
Solved/Closed
Ram
-
Sep 14, 2010 at 07:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 14, 2010 at 10:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 14, 2010 at 10:03 AM
Hello,
I want to a formula for excel documents enter date output day.
for exmample I entered 09/14/2010 then i found tuesday. I try more but not success.
pls help me.
Ram asare maurya
Thanks.
I want to a formula for excel documents enter date output day.
for exmample I entered 09/14/2010 then i found tuesday. I try more but not success.
pls help me.
Ram asare maurya
Thanks.
Related:
- Excel
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 14, 2010 at 10:03 AM
Sep 14, 2010 at 10:03 AM
Hi Ram,
Try this formula:
=IF(WEEKDAY(A1)=1,"Sunday",IF(WEEKDAY(A1)=2,"Monday",IF(WEEKDAY(A1)=3,"Tuesday",IF(WEEKDAY(A1)=4,"Wednesday",IF(WEEKDAY(A1)=5,"Thursday",IF(WEEKDAY(A1)=6,"Friday","Saturday"))))))
Best regards,
Trowa
Try this formula:
=IF(WEEKDAY(A1)=1,"Sunday",IF(WEEKDAY(A1)=2,"Monday",IF(WEEKDAY(A1)=3,"Tuesday",IF(WEEKDAY(A1)=4,"Wednesday",IF(WEEKDAY(A1)=5,"Thursday",IF(WEEKDAY(A1)=6,"Friday","Saturday"))))))
Best regards,
Trowa
