Excel Formula adding 45 days

  • Thread starter Thread starter Stallion
  • Start date Start date
S

Stallion

I need to have a formula where I take the date in E5 which is 4/3/200
then have the formula add 45 days to it and add it to F5 so it roll
the months over n such please help I are newbie at Excel :
 
Assuming E5 is the date

At F5, key in =E5+45

Make sure roll 5 is formatted as date format.

Drag the F5 cell across to keep the dates rolling.

Hope that's what you wanted to know.


Rgds,
Gilbert
 
Back
Top