Date

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I am new to Excel. I have A Column for StartDate, B Column
for Test Date, C Column For Test 2 Date, etc. Test Date is
5 days after StartDate and Test 2 Date is 8 days after the
StartDate. I want to know how to do the following. That is
when I enter the data for A Column , B Column and C Column
should be entered automatically. Another question is if A
Column for StartDate, B Column for Test Date is 6 hours
after the StartDate. How can I do it ? Thanks in advance.
 
Hi Susan
just add the days. e.g. in B1 enter
=A1+5
in C1 enter
=A1+8
format both cells as 'Date'

or if you only want to count workdays use
B1:
=WORKDAY(A1,5)
C1:
=WORKDAY(A1,8)

if you want to add times you just have to know that 1 hour = 1/24 in
Excel. So to add 6 hours to a cell use
=A1+6/24
or
=A1+ TIME(6,0,0)
and format the resulting cell as 'Time' or 'Date/Time')
 
Just add

B

=IF(A1="","",A1+5)

C

=IF(A1="","",A1+8)

copy down

I am not sure I understand the second part

if you want to add 6 hours to a date?

=IF(A1="","",TEXT(A1+6/24,"mm/dd/yy hh:mm"))

will give you the date and hours in a text representation

or numeric

=IF(A1="","",A1+6/24)

custom format

mm/dd/yy hh:mm
 
Back
Top