Mar 20 2023 09:04 AM
=IF(EOMONTH($A18,0)=EOMONTH(AU$1,0),EOMONTH($A18,0)-$A18+1,IF(EOMONTH($O18,0)=EOMONTH(AU$1,0),$O18-EOMONTH($O18,-1),IF(AND(AU$1>$A18,AU$1<$O18),EOMONTH(AU$1,0)-EOMONTH(AU$1,-1),0)))
Good afternoon, I am using this formula for working out the amount of days for each month and this month shows only the amount of days for the entire month, but I am looking to enter a TODAY function, how can I do this??
As some dates start in this month and there is no end date, howcan I shows the days up to today??
Mar 20 2023 10:33 AM
What are you trying to accomplish? It's hard to visualize from a formula without any context.