=dateif

[s1m0ns1m0n]

Probably a simple question but! im trying to calculate the diffrence between two dates so lets say =DATEDIF(B4;B22; "D") wich will give me the diffrence between b22 and b4.. obviously! but b22 is empty, and id like it to go to b21, wich is empty so id like it to go to b 20.. and so on untill it finds a date, wich right know is in b6, objectiv being to see how many days it took me to do a certain thing everytime i add a date in to the spreadsheet without having to change the formula any time! thx in advance! i have been looking on forums and asking people i know for the past two hours lol.. im annoyed thanks in advance! (sorry for my english its not my first language! )

[NBVC]

Try:

=DATEDIF(B4;LOOKUP(9.9999E+307;B5:B22);"D")

[s1m0ns1m0n]

thanks a lot for your help! althaught it didint work i feel like im getting closer, eveything under b4 is now in green,, like it looks like it should and b4 is blue, but it tells me theres an error in the formula and highlights 9.999E really appreciate the help!

[NBVC]

I tested it as a formula and it works, although I use comma separators.

Are you trying to do conditional formatting?

[s1m0ns1m0n]

nope really simple spreadsheet really, althaught my excel is in french.. but usualy formulas in english also work..!