Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
149
Views
Topic starter
Hi all,
I have Emplyoee HireDate and number of sick leave on monthly basis. (please find attached sample data).
I am trying to get, the sum of sick leave days has to reset to Zero autimatically for every 365days/1 year from HireDate.
any help really appreciated!
Thanks,
Pchava
Posted : 15/07/2019 11:49 pm
Hi,
I understand what you are asking but in your sample file, the Expected Output has no data in it and the sample data layout is incomplete?
Maybe using this would do what you want:
=IF(TODAY()=B14,0,SUM(C14:L14))
See attached workbook
Regards
Phil
Posted : 17/07/2019 7:24 pm
