Vacation tracking help [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,
How do i make a cell increase by 40 every 180 days from known date...


1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!