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
Related:
- Excel
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel free download - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Excel date format dd.mm.yyyy - 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
