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
Hello,
How do i make a cell increase by 40 every 180 days from known date...


1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0