User Profile
janist29
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
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 02/04/2021 2nd- using excel help =DATEDIF(TODAY(),I3,"y") In both instances results are the same 00/01/1900 I have attached spreadsheet for your information and the formula am trying to work is on column name-days left.57KViews0likes6Comments
Recent Blog Articles
No content to show