Vacation tracking help
Closed
meman
-
3 May 2016 à 09:15
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 3 May 2016 à 11:15
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 3 May 2016 à 11:15
Related:
- Vacation tracking help
- Fbcdn net tracking - Guide
- Is whatsapp tracking me - Guide
- Spectrum mobile tracking - Guide
- Gift tracking app - Guide
- How to detect gps tracking on your cell phone - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
3 May 2016 à 11:15
3 May 2016 à 11:15
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
