Formula to convert date in number format into words

[chrono2483]

Hello,

I have the date in a number format (Ex. 3/19/16, based on my computer settings). I am currently using the following formula in cell O3, which extracts the weekday with no problem: "CHOOSE(WEEKDAY(LEFT('Output'!E1,3)),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")"

What I want to do in cell O4 is have a formula to recognize the day in O3 and output the next day. In the above example, O3="Saturday", therefore I would want O4="Sunday".

Is there a formula that would accomplish this?

 

[Jonmo1]

Here's a much simpler way to extract the Day Text Name

=TEXT('Output'!E1,"dddd")

To get the 'Next' day, instead of trying to get that from the previous formula O3
I'd suggest just adding 1 to the original date and repeat the same formula
=TEXT('Output'!E1+1,"dddd")

Hope that helps.

 

[chrono2483]

Perfect - much easier as well - thank you very much!!!!

 

[Jonmo1]

You're welcome.