Turn Date into numeric value

I would like to follow a task and see the difference between when it was planned and actually done.

To be more precise.

Column "Agreed Date" is used on what date the two parties agreed to finish the task

Colum "Final Date" should show what day the task was really done. This should not change based on date, but should be a numeric value (or similar)

Delta should show, what was the difference between final and agreed date.

Is there an easy approach to this?

I have a total blackout on how to solve this I think pretty easy topic. THANKS

Find more posts tagged with

Formulas

Comments

Mike Wilday

Hi Dan,

Try using the Netdays Function or the Networkdays function for calculating the number of days between two dates.

=Netdays([Final Date]1, [Agreed Days]1)

https://help.smartsheet.com/function/netdays

=Networkdays([Final Date]1, [Agreed Days]1)

https://help.smartsheet.com/function/networkdays

ielektra

While the problem being provided was solved. The title is completely wrong for the question and response. I'm trying to find a real answer to how to Turn a Date into a Numeric value. I'm not looking for net days, I'm look for the numeric date value of a date, for use in a formula. Smartsheet help is being..really unhelpful

Genevieve P.

Hi @ielektra

You could use either the MONTH, DAY, or YEAR function to pull the number from a date column of any of those parts of the date. You can even add them together with a / between them to recreate a date:

=MONTH(Date@row) + “/” + DAY(Date@row) + “/” + YEAR(Date@row)

Or you could potentially embed one of these functions into the other formula you mentioned. Would you be able to describe your desired result in more detail, perhaps with screen captures of your sheet? (But please block out any sensitive data). It would be very helpful to see the other formula you referenced, if possible.

Thanks!

Genevieve

Andrée Starå

Hi, @ielektra

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

To turn a date into a numeric value (generally for establishing unique ID's), I generally pull the numbers in a yyyymmdd format then wrap it in a VALUE function.

=VALUE(YEAR(Date@row) + "" + IF(MONTH(Date@row) < 10, "0") + MONTH(Date@row) + "" + IF(DAY(Date@row) < 10, "0") + DAY(Date@row))

Jared Agee

I have a habit of turning dates into a number by using the following formula…

=(YEAR([Submission Date]@row) * 365) + FLOOR(YEAR([Submission Date]@row) / 4, 1) + YEARDAY([Submission Date]@row)

Seems like NETWORKDAYS might simplify this a lot…

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…