Remember Me?

#1
April 5th 05, 02:11 PM
 Jomo Watts Posts: n/a
auto dating after entering the first date

I have a Timesheet that has a row of dates for a two week period, I would
like to enter the first date and have the rest of the remaining days auto
compute the correct date. I used to have a Timesheet that had a formula for
this but I'am no longer able to find it.

Thanks

#2
April 5th 05, 02:29 PM
 Fred Posts: n/a

Jomo Watts wrote:
I have a Timesheet that has a row of dates for a two week period, I

would
like to enter the first date and have the rest of the remaining days

auto
compute the correct date. I used to have a Timesheet that had a

formula for
this but I'am no longer able to find it.

Thanks

If your date appears in cell A1, for instance, then cell A2 could
contain the formula =A1+1; cell A3 could contain =A2+1..... Just copy
down as many rows to complete your two week period.

#3
April 5th 05, 03:05 PM
 Jomo Watts Posts: n/a

Thanks Fred it worked perfect!

"Fred" wrote:

Jomo Watts wrote:
I have a Timesheet that has a row of dates for a two week period, I

would
like to enter the first date and have the rest of the remaining days

auto
compute the correct date. I used to have a Timesheet that had a

formula for
this but I'am no longer able to find it.

Thanks

If your date appears in cell A1, for instance, then cell A2 could
contain the formula =A1+1; cell A3 could contain =A2+1..... Just copy
down as many rows to complete your two week period.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post hpkcommish Excel Discussion (Misc queries) 2 February 22nd 05 10:23 AM Krit Kasem Excel Discussion (Misc queries) 2 January 14th 05 02:55 AM sj Excel Discussion (Misc queries) 6 January 6th 05 03:07 PM Richard Rosell Excel Worksheet Functions 2 December 27th 04 03:26 PM brhicks Charts and Charting in Excel 3 December 16th 04 02:54 PM

All times are GMT +1. The time now is 01:38 AM.