Date -time subtraction..
Solved/Closed
sunny2u86
Posts
14
Registration date
Thursday 2 February 2012
Status
Member
Last seen
4 June 2012
-
2 Jun 2012 à 10:40
Blocked Profile - 4 Jun 2012 à 06:01
Blocked Profile - 4 Jun 2012 à 06:01
Related:
- Date -time subtraction..
- Popcorn time download - Download - Movies, series and TV
- Facebook id verification time - Guide
- Ocarina of time rom - Download - Action and adventure
- Why does facebook refresh all the time - Guide
- Ps3 controller charge time - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
4 Jun 2012 à 05:54
4 Jun 2012 à 05:54
suppose data is A1 to B6
in C1 type this formula
=NOW()-A1
in D1 type this formula
=DAY(C1)
highlight c1 and d1 and copy them down
in C1 type this formula
=NOW()-A1
in D1 type this formula
=DAY(C1)
highlight c1 and d1 and copy them down
Greetings,
Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.
Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse
Please, copy, modify and repost your message respecting the politeness charter.
We trust that you understand.
Moderator
Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.
Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse
Please, copy, modify and repost your message respecting the politeness charter.
We trust that you understand.
Moderator