Vacation tracking help
Closed
meman
-
May 3, 2016 at 09:15 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - May 3, 2016 at 11:15 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - May 3, 2016 at 11:15 AM
Related:
- Vacation tracking help
- Spectrum mobile tracking - Guide
- Fbcdn.net tracking - Guide
- How to know if someone is tracking your whatsapp - Guide
- Mouse not tracking properly - Guide
- Viber location tracking - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
May 3, 2016 at 11:15 AM
May 3, 2016 at 11:15 AM
Hi Meman,
Try this:
=INT((TODAY()-A1)/180)*40
So subtract the known date in A1 from today's date and divide that by 180. Then round it down (INT) and multiply by 40.
Best regards,
Trowa
Try this:
=INT((TODAY()-A1)/180)*40
So subtract the known date in A1 from today's date and divide that by 180. Then round it down (INT) and multiply by 40.
Best regards,
Trowa
