Date formula

[Jyggalag]

Hi all,

I am calculating depreciations like this:

However, my formula ONLY calculates depreciation for january if the date in column B = 01-01-2024.

Is there any way to change it, so it calculates this as long as the date in column B is in the same month as in the date mentioned in column F? and i need to pull the formula to the right to future months, so feb-24, mar-24.... jan-25.... mar-26 etc.

Would really appreciate some help!

 

[Jyggalag]

Give this a try:

=IF(
   AND(EOMONTH(F$3,0)>=EOMONTH($B7,0),
       EOMONTH(F$3,0)<EOMONTH($B7,$D7*12)),
   $E7,0)

Absolutely amazing Alex, thank you so much!!! Truly appreciated

 

[Alex Blakenburg]

You're welcome. Glad we could help.