Vacation tracking help
Closed
meman
-
May 3, 2016 at 09:15 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 3, 2016 at 11:15 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 3, 2016 at 11:15 AM
Related:
- Vacation tracking help
- How to know if someone is tracking your whatsapp - Guide
- Bank account tracking download - Download - Finance
- Best baby tracking app - Guide
- Vacation responder outlook app - Guide
- Viber location tracking - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
