#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Show date as day of the week

2»

• edited 06/12/16

Thank you John Hinkle... I found your proposed solution to be the simplest and most graceful of all suggested.

Well done.

• ✭✭✭

Hi, Brett -

Can you tell me how your solution determines items due in the current calendar week? I need to create a report that shows past due items and items due in the current calendar week. I also need a report that shows items due in the next calendar week.

• ✭✭✭✭✭✭
• I came across this page while looking for this workaround but I didn't like having to use a bunch of intermediary cells.  Because modulo division also requires a workaround I eventually arrived at this monster

=IF(ISBLANK([APPT DATE]1), "", (IF((INT(([APPT DATE]1 - DATE(1999, 12, 26))) - INT(([APPT DATE]1 - DATE(1999, 12, 26)) / 7) * 7) = 0, "Sunday", IF((INT(([APPT DATE]1 - DATE(1999, 12, 26))) - INT(([APPT DATE]1 - DATE(1999, 12, 26)) / 7) * 7) = 1, "Monday", IF((INT(([APPT DATE]1 - DATE(1999, 12, 26))) - INT(([APPT DATE]1 - DATE(1999, 12, 26)) / 7) * 7) = 2, "Tuesday", IF((INT(([APPT DATE]1 - DATE(1999, 12, 26))) - INT(([APPT DATE]1 - DATE(1999, 12, 26)) / 7) * 7) = 3, "Wednesday", IF((INT(([APPT DATE]1 - DATE(1999, 12, 26))) - INT(([APPT DATE]1 - DATE(1999, 12, 26)) / 7) * 7) = 4, "Thursday", IF((INT(([APPT DATE]1 - DATE(1999, 12, 26))) - INT(([APPT DATE]1 - DATE(1999, 12, 26)) / 7) * 7) = 5, "Friday", IF((INT(([APPT DATE]1 - DATE(1999, 12, 26))) - INT(([APPT DATE]1 - DATE(1999, 12, 26)) / 7) * 7) = 6, "Saturday", IF(ISBLANK([APPT DATE]1), "", "")))))))) + ", " + [APPT DATE]1))

But this will reference a cell containing a date ([APPT DATE]1 in this case) in the format "04/13/18" and turn it into "Friday, 04/13/18".  Only works for dates this century, though you could push the Sunday I subtract further back if you really needed to.

• ✭✭✭✭✭✭

Thanks so much for sharing this! This is exactly what I was looking for and saved me so much time!

• Excellent!  Thank you for posting this!

• Thanks JohnHinkle.  Worked perfectly for me.

This discussion has been closed.