Previous Topic Next Topic

Hi All can you help me with the formula i require below

Closed
noelmitc Posts 1 Registration date Monday June 23, 2014 Status Member Last seen June 23, 2014 - Jun 23, 2014 at 12:29 PM
 RayH - Jun 24, 2014 at 03:04 PM
Im looking for a formula that will look at a number in row b and if that number is 1 will add 1 day from the date in row c and put it in row e, and if row b has 2 add 2 days in e and so on,
New to excel so any help would be appreciated.
Related:

1 response

Answer 1 / 1
RayH
Jun 24, 2014 at 03:04 PM
I think its just as simple as:
In the E2 cell put 
=B2+C2

where C2 is the date and B2 is the number.
Make sure E2 is formatted for dates.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response