Formula:![]()
=IF($F2<G$1,"No",IF(MONTH($F2)=MONTH(G$1),DAY($F2),DAY(EOMONTH(G$1,0))))
Formula:![]()
=IF($F2<G$1,"No",IF(MONTH($F2)=MONTH(G$1),DAY($F2),DAY(EOMONTH(G$1,0))))
Hi Shareez- Thanks for your support. I found some anomalies with the formula especially if the start date is in 2020 and end date is in 2020 or 2021.
row numbers 7,31,36,38,43 have this issue.
Could you please look into it?
Additionally- how do I attach the file while I reply?
Regards,
SSP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks