Formatting cell and doing date arithmetic
 

Hi all,

This is probably a simple question for you all.

I would like to display the following:

dd-mmm-yy to dd+7-mmm-yy

for example, for today, the cell should read "13-Jan-2004 to 20-Jan-2004"

Any ideas?

Thanks,
Stephen

Formatting cell and doing date arithmetic
 

On Tue, 13 Jan 2004 10:46:14 -0700, "Stephen Closson"
wrote:

Hi all,

This is probably a simple question for you all.

I would like to display the following:

dd-mmm-yy to dd+7-mmm-yy

for example, for today, the cell should read "13-Jan-2004 to 20-Jan-2004"

Any ideas?

Thanks,
Stephen



One way:

=TEXT(TODAY(),"dd-mmm-yyyy") & " to " & TEXT(TODAY()+7,"dd-mmm-yyyy")


--ron