Date ranges

R

Rus

I am trying to complete a worksheet that will put in a
date from the past two weeks until todays date. i.e. it
would say "from the period dd/mm/yy until todays date"
This would need to be done automatically each time I log
onto the worksheet. I hope my problem makes sense to
someone.

Thanks

Rus
 
F

Frank Kabel

Hi
in A1 put the following formula
=TODAY()-14+ROW(1:1)
and copy this down for 14 rows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top