Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Tue 7 Oct 2008, 17:13 Delegate Matthew said...

Matthew has attended:
Excel Intermediate course

Excel

How do you post a formula using the today function to work out how many days would be left on a contract?

Fri 10 Oct 2008, 16:47 Trainer Andrew said...

RE: Excel

Hi Matthew

Thanks for your question. You could use a formula as follows:

=A1-today()

Where A1 contains the expiry date of the contract. You may need to format the result as a general number.

I hope this helps - let us know if you need any further information.

Kind regards,

Andrew

Training courses

98.5 % recommend us

More live stats...

Training information:

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips