Date formula

  • Thread starter Thread starter andypw1981
  • Start date Start date
A

andypw1981

Hi, gr8 forum here. Just a quick question:

I am creating a spreadsheet for work. I have 3 colums-
1)Date entered (dd/mm/yy)
2)No. Of weeks
3)Date of review (dd/mm/yy)

It is probably quite simple but what i'd like to do is to be able to d
a formula which adds say 6 weeks on from the day it was entered int
the database and the result comes in the format of dd/mm/yy in colu
3.

Any help will be appreciated.

Many thanks in advance.

:) Andy :
 
Thanks for the help so far guys.

When pre-formatting the cells before I enter any information into them
is there any way to get rid of the 'invalid date' in the formula cell
before a date is calculated?

Many thanks once again.

And
 
Hi Andy:

Re: When pre-formatting the cells before I enter any information into them,
is there any way to get rid of the 'invalid date' in the formula cells
before a date is calculated?

You could use:

=IF(A1="","",A1+(6*7))


--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top