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:

=TEXT((D2),"ddd")

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]

Range("D2")=Date
?Range("D2").Value
10/08/2015 
Range("E2").Value=Range("D2").Value+1
?Range("E2").Value
11/08/2015 
?Format(Range("E2").Value,"dddd")
Tuesday
Range("F2").Value=Format(Range("D2").Value+1,"dddd")
?Range("F2").Value
Tuesday

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!