=Today()

[Woody Pecker]

I know I'm going to sound thick, but I just can't get this to work.

I have a formula that needs to report back "dddd dd/mm/yyyy" based on =Today(), but if =Today()="Friday" I need it to report "dddd dd/mm/yyyy" as 3 days later, but for any other day just report the next day.

Please help because it's driving me absolutely nuts & I know it's a simple answer.

 

[MARK858]

If today was a Thursday what should it report back? Friday or Saturday?

 

[etaf]

=IF( WEEKDAY(A1,1)=6, TODAY()+3, TODAY())

 

[Woody Pecker]

Excellent, I knew it was simple, feeling a tad thick.

 

[Peter_SSs]

I have a formula that needs to report back "dddd dd/mm/yyyy" based on =Today(), but if =Today()="Friday" I need it to report "dddd dd/mm/yyyy" as 3 days later, but for any other day just report the next day.

Sounds like you could use
=WORKDAY(TODAY(),1)
& format the cell as "dddd dd/mm/yyyy"

or if you want text returned
=TEXT(WORKDAY(TODAY(),1),"dddd dd/mm/yyyy")

 

[etaf]

you are welcome

 

[n1lesh]

try This

=IF(WEEKDAY(TODAY(),2)=5,TODAY()+3,TODAY()+1)

 

[MARK858]

Excellent, I knew it was simple, feeling a tad thick.

Are you sure? doesn't that formula for days that aren't Friday return Today's date and not Today + 1?
I think you should look the 2 formula Peter posted in post #5.

 

[Woody Pecker]

It works fine thanks, everything I needed