# Trying to Calculate a Date

Options
edited 09/01/23

I am trying to calculate a date between today and a static date like 10/20/2023. I cannot seem to get a result?

• ✭✭✭✭
Options

If you need total days between today and 10/20/2023, you can try Ray's formula.

=[Date1]@row - TODAY()

Replace "Date1" with your date column name.

If you need total networking days between today and 10/20/2023, you can try the below formula.

=NETWORKDAYS([Date1]@row, TODAY())

Options

Thanks

• ✭✭✭✭✭✭
Options

Try this:

=TODAY() - [Date1]@row

Replace "Date1" with your date column name.

BRgds,

-Ray

• ✭✭✭✭✭✭
Options

Hi @Tim Riggle,

Not 100% sure what you mean by a date between today and a static date. Are you looking for the number of days, number of working days or a certain point (e.g. halfway) between today and the other date?

• Options

I am trying to calculate the number of days from today to a date in a specific row, which is the live date.

• ✭✭✭✭
Options

If you need total days between today and 10/20/2023, you can try Ray's formula.

=[Date1]@row - TODAY()

Replace "Date1" with your date column name.

If you need total networking days between today and 10/20/2023, you can try the below formula.

=NETWORKDAYS([Date1]@row, TODAY())