Got something to say or just want fewer pesky ads? Join us... 😊

Excel formula help please.



Garage_Doors

Originally the Swankers
Jun 28, 2008
11,789
Brighton
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.
 




Simster

"the man's an arse"
Jul 7, 2003
54,110
Surrey
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
 










Garage_Doors

Originally the Swankers
Jun 28, 2008
11,789
Brighton
Can i add to this please :blush:

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

cheers :thumbsup:
 























Paying the bills

Latest Discussions

Paying the bills

Paying the bills

Paying the bills

Albion and Premier League latest from Sky Sports


Top
Link Here