https://www.dropbox.com/s/r3p63j9aeshtiq9/test.xlsx?dl=0
Hi,
I'm trying the following requirements from the attached excel and not getting. Can anyone please help.
1. Every month should be added 2 in CL column automatically based on date criteria. (I used today() with IF function).
2. If leaves in FEB and so on... It should minus from 2018 Balance till it's zero then From Jan Month. Example: If no leave in Jan and Feb have 2 leaves, Its priority like 2018 balance then Jan. If 2018 balance and Jan leave balance is zero, then Feb leaves balance is zero.
3. Is it possible that every formula based on ID as criteria?
Hi,
I'm trying the following requirements from the attached excel and not getting. Can anyone please help.
1. Every month should be added 2 in CL column automatically based on date criteria. (I used today() with IF function).
2. If leaves in FEB and so on... It should minus from 2018 Balance till it's zero then From Jan Month. Example: If no leave in Jan and Feb have 2 leaves, Its priority like 2018 balance then Jan. If 2018 balance and Jan leave balance is zero, then Feb leaves balance is zero.
3. Is it possible that every formula based on ID as criteria?