week ending date?

[SRussell]

Hi folks.

I'm trying to insert a formula into a cell which would return the week ending date.

i.e if I was to look at this week the date I would want returned would be 13/04/08

I currently use some vba code to format the filename with the week ending date

Please Login or Register  to view this content.

but don't know how I would translate this into a cell formula.

Can anyone help?

[daddylonglegs]

Try

=TODAY()+7-WEEKDAY(TODAY()-1)

[oldchippy]

How about this?

=TODAY()+7-WEEKDAY(TODAY()-1)

[broro183]

hi

Try
=TODAY()+(7-WEEKDAY(TODAY(),2))

If you have other questions about dates you may find Chip's many Date & Time pages useful too:

http://www.cpearson.com/Excel/datetime.htm

hth
Rob

Edit: Ooopps!
I'm a bit slow off the mark today, that'll teach me for wandering off to get breakie - now you have an answer in triplicate, hopefully the link is useful though...

[SRussell]

thanks guys, that works.