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.

1 reply

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