based on the provided date and current date need count of running total year, month and days
Example excel attached.
For example
1-Jan-19 is the incident date
and
assuming current date 26.feb/2020
Date Year Month Day
1-Jan-19 1 1 26
requirement to display year, month, and day.
you can replace today() function in sheet with the date you want to lets say you have date in E2 then you can use below in B2
replace red part with E2Formula:
Please Login or Register to view this content.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks