Excel formula help please.

[Garage_Doors]

I have searched the net for this ! But each one I have found just adds a predetermined number to a date.
I want it to be able to count days fluidly,

Its for invoicing so when I issue on on a given date I want to be able to just read in the spread sheet how many days old it is,
So it counts days each time its open.
I though this would be an easy common formula. But I can’t find it.

Any NSC excel wizards on here please.

 

[MattBackHome]

=TODAY()-B2

B2 contains the invoice date.


Format as Number with 0 decimals.

 

[Simster]

So if your invoice date is in cell A1, just have another cell with the formula "=TODAY()-$A$1"

Gives number of days since invoice date

 

[Titanic]

Can't you just do =TODAY()-Xn (in a cell formatted as a basic number)

 

[Titanic]

Sorry - didn't see the other very helpful and accurate responses. Is there anything NSC doesn't know??

 

[Garage_Doors]

Thanks Guys !
Really appreciate it

 

[Garage_Doors]

Can i add to this please

How do i make it go red once its over 31 days !

cheers

 

[seagully]

Can i add to this please

How do i make it go red once its over 31 days !

cheers

Conditional Formatting>Highlight Cells Rules>Greater Than. Then enter 30 into the box.

Obviously this will only work if you are using the already mentioned date formulas

 

[Driver8]

Can i add to this please

How do i make it go red once its over 31 days !

cheers

Home, Styles, Conditional Formatting, Highlight Cells Rules, select whichever one you want

 

[MattBackHome]

Can i add to this please

How do i make it go red once its over 31 days !

cheers

Conditional formatting - New Rule - "Format only cells that contain" etc

Simples!

 

[Garage_Doors]

You guys are good, or need to get out more

Thanks again.

 

[GreersElbow]

Sorry - didn't see the other very helpful and accurate responses. Is there anything NSC doesn't know??

Airspeed velocity of a unladen Swallow?

 

[The Stout Yeoman]

Can i add to this please

How do i make it go red once its over 31 days !

cheers

Keep rubbing vigourously ?

 

[WATFORD zero]

Airspeed velocity of a unladen Swallow?

European or African ?

 

[KZNSeagull]

Airspeed velocity of a unladen Swallow?

Terminal, if it is in free fall.

El Pres will be along later with his unique interpretation of the question.