Forum Discussion
janist29
Jan 29, 2021Copper Contributor
Excel date difference formula (Today)
Hi, I am trying to calculate difference between today and expiry date I tried 2 approaches: 1st- using a following formula =I3-today() I3 is my expiry date which is written in date format 0...
mathetes
Jan 29, 2021Silver Contributor
Changed the DATEDIF function to read =DATEDIF(TODAY(),I3,"d") and the formatting of the cell to number and remove the decimal.