Date Formulas

[tobyhutton1234]

Hi There,

Need abit of help counting the ammout of days between two date.

Lets say i'm using A1 as the start date and B1 as the end date. I can do it simply by using =B1-A1 and that will return the days.

What I need to do is this. Start date in A1 and if there is no end date in B1 then it should automatically count from the currrent date.

The number of days will return in (lets say) C1

Any thoughts,

Thanks

 

[VoG]

Try

=IF(B1="",TODAY()-A1,B1-A1)

 

[tobyhutton1234]

Yep that works great, the only thing, I get in every other cell number in row C (C being where the number of days will return) it will return 41038, that's because there's no dates in A2 & B2 (and so on and so on). Is there anyway I can remove them until a date in row A has been entered.

Hope that makes sense. I have included a screenshot.

 

[VoG]

Try

=IF(A1="","",IF(B1="",TODAY()-A1,B1-A1))

 

[tobyhutton1234]

fantastic, works a treat.

Thank You.