Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training in london - dates

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in london - Dates

excel training in london - Dates

ResolvedVersion Standard

Andrew has attended:
Excel Advanced course

Dates

In Excel can you program a formulae to take a date (Invoice Date) and add 30 days etc.

RE: Dates

Hi Andrew,

Have you tried to take a date say in A1 and in your destination formula put =A1 +30? ensuring you format the cells to read the number or do you want something more complicated? I would doubt whether you could set this type of construction inbuilt...

regards

Tracy

Excel tip:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.