Autonumber and autodate

  • Thread starter Thread starter dkenebre
  • Start date Start date
D

dkenebre

Is there a way to automatically have the date be updated and the next
number in the record be updated when a value is entered into the chart.
see the following:


,,,,,,,,,,,,Value,,,,,,,,,,,,Date Monday-Saturday Only,,,,,,,Record
,,,,,,,,,,,,432,,,,,,,,,,,,,,,Mon-12/02/02,,,,,,,,,,,,,,,,,,,,,,,,,,,,,15
,,,,,,,,,,,,657,,,,,,,,,,,,,,,Tues-12/03/02,,,,,,,,,,,,,,,,,,,,,,,,,,,,16
,,,,,,,,,,,,372,,,,,,,,,,,,Autodate,,,,,,,,Autonumber

and so on.....
 
If there is one entry per day, Monday through Saturday.

assume value is in column A

assume 372 is in row 3, so in B3

=if(A3<>"",if(Weekday(B2+1,1)=1,B2+2,B2+1),"")

in C3
=if(A3<>"",C2+1,"")

Select B2:C2 and drag fill down the column.

format column B as ddd-mm/dd/yy
 
Back
Top