Date ranges

  • Thread starter Thread starter Rus
  • Start date Start date
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
 
Hi
in A1 put the following formula
=TODAY()-14+ROW(1:1)
and copy this down for 14 rows
 
Back
Top