Friday, September 18, 2020

Minus/Subtract 2 dates in Excel, Result is not showing in Number of Days

I was working in excel and trying to subtract 2 dates. Minus old date from today date to find the ages of something in number of days.

But when i apply formula "=Today()-A2" in excel it is showing output not as expected.

Problem : Column formatting is not set

Solution : Right click the column and > Format > Change formatting to "Text" or "General"





No comments:

Post a Comment

web stats