Request for Excel Formula
Hi Bob,
A5 is the first date. If you can imagine a time sheet, in Row A is days of
week and under each day of the week or several spaces before next day of
week. Underneath day of week Monday in Row A is the date. These dates are
the ones I would like to update. It is a 2 week time sheet.
klt
"Bob Phillips" wrote:
What is the relationship between the dates? does the first go in A5 or
somewhere else?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"klt" wrote in message
...
Formula to increment dates (Ex. Monday 4/11/2005) in one column and on
multiple (not consecutive) rows. Ex. A5, A15, A25, A32, A40, A49, A57,
A68,
A79, and A90.
I don't know if there is a formula that can automatically update the
dates,
but if not, maybe if the user updates the first date, the others can
update
automatically. Is either a possibility or are they impossible? I am not a
programmer, so if difficult, please explain how it is done.
|