Walker_Ice
Board Regular
- Joined
- Oct 6, 2023
- Messages
- 53
- Office Version
- 2021
- Platform
- MacOS
Hi everyone,
This IF AND formula does not seem to be working and i can't figure out why. Can someone please help?
thANK YOU.
=IF(AND([@Type]="income",shift_late_income_status="Active",DAY([@Date]>=shift_late_income_starting_day),
DATE(YEAR([@Date]),MONTH([@Date])+1,1),
[@Date]))
This IF AND formula does not seem to be working and i can't figure out why. Can someone please help?
thANK YOU.
=IF(AND([@Type]="income",shift_late_income_status="Active",DAY([@Date]>=shift_late_income_starting_day),
DATE(YEAR([@Date]),MONTH([@Date])+1,1),
[@Date]))