Days Since (Single Date)

James Maxwell

I have to do some invoicing and want to know how many days since an invoice was issued. I can sort out how to find the days between two dates but I only have one date to work with here.

 

Would love if someone could help!

Tony Davidson - SmartSheet Certified User 2016

Hi James.. I found a nice template you could utilize below.  I'm sure if you email support@smartsheet.com they could help build a formula in this sheet in a new column for your "days since invoiced".

 

https://www.smartsheet.com/solutions/customer-order-tracking-and-history

Shaine Greenwood

Hello All—

 

Although our Support team is always there to help troubleshoot existing formula behavior, it sounds like you don't have a formula yet; let's fix that! 

 

To be clear, are you looking to take the number of days between your last invoice date and the current date? You can place a formula like =TODAY() - [Invoice Date]1 in a text/number column. This will take the difference between the current date and your invoice date, then provide you with a numeric value.

 

Let me know if that's not what you were looking for and I can take another look.

James Maxwell

Hi Shaine, this worked perfectly. Thank you very much!

Molnar

Hey,

How am I supposed to type in the "invoice" date?