columns

G

Guest

Working on a spreadsheet I call "Weekly Activity Report" for employees. It
has columns as follows:
date-code-hours-notes

If I enter a date x/x/xx, how can I set this column up to fill in the rest
of the dates in for me if I have them labeled m-sun in the first column or is
this even possible?

m x/x/xx
l
sun x/x/xx
 
V

VBA Noob

If your start date is in B2 say then click on C2 and put this formul
in

B2 +1

That should work

VBA Noo
 
G

Guest

Or you can fill in the first date cell. Exit the cell. now click the lower
rihgt corner of that cell. While holding down on your mouse left button,
drag down for the number of days you want to fill in. Each row will increase
by one day.
 

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