Function for adding days

  • Thread starter Thread starter Dale Holden
  • Start date Start date
D

Dale Holden

Hi

I am sure this is simple so i appologise now. I have a work sheet with
dates in them i have it so when i change the 1st date every date after
that auto changes to the days after and so on

Eg A1 01/01/2004 when that date is entered B1 puts in 01/01/04 and so
on its a simple = a1=1 function.


Over these dates i have days of the week Mon Tue etc i want the days
to link to dates and update automatical;ly with the right date.

Can this be done?

Cheers Dale
 
Hi Dale!

Your posting is very confused.

To add 1 day to a date use:

=A1+1

If you only want working days, then use:

=WORKDAYS(A1,1)

If you want to see just the day of week, then use the custom format
ddd or dddd
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Norman yes it is i didnt read it properly.

I have the dates changing with the sum you stated A1+1 (In cell B1) this
adds a date on, no problem.


But above the dates i have days Mon Tue Wed Thu etc, i want a formula to
look at the date entered 13/04/03 then inser Sat then copy that formula to
every day cell so it looks at the date cell below and changes it to the
correct day for the date below it.

Hope that makes sense

Cheers Dale
 
Hi
if your dates are in row 2 (starting in column A) enter the following
in A1
=A2
and format this cell (goto 'Format - Cells') with the custom format
"ddd")
copy this formula to the right.

another way: enter the formula
=TEXT(A2,"ddd")
in A1 and copy to the left
 
I have tried that but keep getting an error message saying i have selected
wrong date and to check my diary?
 
Hi All!

Problem solved off group!

What Dale was wanting was for SAT etc to appear above the date in the
cell below where the cell below was based on an entry elsewhere. Then
he needed to copy across.

It's the cell above that you change!

=cell_below
Format ddd

So if your date entry is in A1
And in (say) A12 you have =A1
In A11 use =a12 and format ddd

If you want it exactly SAT SUN etc you have to use:

=UPPER(TEXT(A12,"ddd"))

But here the entry in A11 is text not date serial number

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I have tried that but keep getting an error message saying i have selected
wrong date and to check my diary?
 
Hi Dale!

I've not seen that error message before. Sounds like a custom data
validation is in existence.

Exactly how are you entering dates?
What country are you in?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I am in the UK the dates are entered as 05/04/2004 i have Office 2003 at
home nd office 97 at work and get the same error???
 
Hi Dale!

We use the same date entry system in Australia. Send the workbook to
the address below and I'll apply a four pound club hammer to it.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Dale!

I think it was just an error with the base date that caused the
problem on just one sheet. All seems sweet now. (famous last words).

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
news:[email protected]...
 
Back
Top