Trying to Calculate a Date

Tim Riggle

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

Shanky Paul

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())

Tim Riggle

Thanks

Ray Lindstrom

@Tim Riggle,

Try this:

=TODAY() - [Date1]@row

Replace "Date1" with your date column name.

BRgds,

-Ray

Nick Korna

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?

Tim Riggle

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

Shanky Paul

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())

Tim Riggle

Thanks