Forum Discussion
Calculate # of days from start & finish dates etc.
Hi all. I'm needing to calculate the number of days employed for the financial year if there is either a start and/or a finish date. But if both are blank, as it is for the employee in Row 7, then I ...
Hi Karen,
Perhaps if FY starts on Jul 01, it ends on Jun 30, not on the day when next FY starts. And you have date out of FY, is that typo or not?
For such data formula could be
=MIN($L$4*(K6<$L$3)+K6-MAX(J6,$L$3)+1,365)
if end date is out of FY, otherwise MIN() is not required