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.

Hi All can you help me with the formula i require below
Logitech formula vibration feedback wheel driver - Download - Drivers
Credit summation formula - Guide
Number to words in excel formula - Guide
Formula spreadsheet definition - Guide
Date formula in excel dd/mm/yyyy - Guide

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.

Similar discussions

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

Help! Volume does not contain a recognized fi

Similar discussions

Subscribe To Our Newsletter!