Formula to add 1 day (and return result of day NOT date)

[Jess0121]

Hi everyone,

I am trying to create a formula to add one day. For example: I run a report that updates nightly and I run it the subsequent morning for the prior day's results. I have an existing line that tells me that 9/1/15 is a Tuesday, but I'm trying to add another row called "run day" and I'd like that to populate as Wednesday (the day I run the report for Tuesday's results). Any ideas? Everything I've found only tells me how to return a date.

Here is the existing formula to populate the actual day:

Please Login or Register  to view this content.

Thanks in advance!

[Tony Valko]

Not quite sure what you're asking...

If D2 = 9/1/2015 (Tue) but you want the cell to return Wed... just add 1 to the cell like this...

=TEXT(D2+1,"ddd")

[ChemistB]

I may be missing something here but

=TEXT(D2+1, "ddd")

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Jess0121]

Apologies for the simplicity. High on cold medicine this morning. Thanks very much!

[Tony Valko]

You're welcome. We appreciate the feedback!