Formatting cell and doing date arithmetic

  • Thread starter Thread starter Stephen Closson
  • Start date Start date
S

Stephen Closson

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
 
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
Click to expand...


One way:

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


--ron
 
Back
Top