Date

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

One column has the date which I enter manually. If I type 15may it converts
immediately to 15-May which is great. But how can I get the line to enter
dates automatically?

What I need is to enter one date (say, 20 May) and for all lines below to
automatically add 1 day at a time, either at the time of starting the line,
or even before in one go.

Thank you very much

JB
 
You can use a formula, if you add the date in A2, in A3 put


=IF(A2="","",A2+1)

copy down as long as needed and format the cells the same way as in A2


--


Regards,


Peo Sjoblom
 
Sorry but I did not get it.

In F4 I have 08-May. I would like the cells below (F5, F6, etc), in the
same column to read automatically: 09-May, 10-May, etc, ad infinitum.

JB
 
In F5 use

=IF(F4="","",F4+1)

format as the date you want and copy down.

This assumes you have a numerical date in F4, you can tell that is you
format F4 as General and you should see 39941 (number of days since Jan 0
1900) assuming that you mean May 8th 2009. If it won't change then you have
text and that is not a date in Excel

--


Regards,


Peo Sjoblom
 
Thanks, but I didn't get it. I end up with numbers like you said, but I
need them to be converted to a standard date format.

JB
 
Just format it the way you want. Make sure 15-May is really May 15th 2009

--


Regards,


Peo Sjoblom
 
Hello Peo

I did what you suggested and indeed got the date as I wanted. However,
after a few weeks, I start to get lots of lines like ############### where
the date should be. I may have only one before the date jumps to the
correct position further down; or I may have 3, 4 or 5 lines.
Interestingly, if you ignore those lines, assuming that they had a date, the
following dates are correct in the correct places.
Any idea what is going on?

Thank you

JB
 
Back
Top