Days between two dates (with conditions)

[JustMax]

Hi all,

I'm trying to post a question about a formula and every time I try, I get a message that says I'm not allowed to posts links or videos. My post has no links or videos. Just the formula and my question.
I can't find a "help" section for posting issues either.
I even tried copypaste my question within this post and the message about links not allowed came back again. I have no links. Just a formula. Help?!

[unit285]

Hi all,

I'm trying to post a question about a formula and every time I try, I get a message that says I'm not allowed to posts links or videos. My post has no links or videos. Just the formula and my question.
I can't find a "help" section for posting issues either.
I even tried copypaste my question within this post and the message about links not allowed came back again. I have no links. Just a formula. Help?!

Are you using Formula Tags like this?

Please Login or Register  to view this content.

[FDibbins]

Max, welcome to the forum

1st, you can only post links after having 10 posts or more. This is to assist in preventing spam. (I know, you said you were not posting links)
2nd, if your formula (that you are trying to post) contains < or > make sure you leave a space each side, otherwise the bot thinks you are posting HTML code

[JustMax]

Thanks unit285 and FDibbins. I rewrote the formula to remove brackets and space after =. Not sure if that was the issue.

This is my original post:

I'm trying to calculate the number of weekdays a piece of equipment was at a specific location*.
I have column D for Delivery date and Column E for Pickup date. On Column F, I used the Networkdays formula to get the number of days the equipment was at that location.
However, if the equipment has not been picked up yet at the time I'm running the report (which is weekly), then I want to calculate the number of days that equipment has been at that location since delivery date and up to the day I am running the report. Outside of the table I have Cellsfor "report date" and =today()
I tried this formula but it doesn't work if the pickup date cell is blank: = IF(Pickup Date=" ",NETWORKDAYS(Delivery Date,TODAY()),NETWORKDAYS(Delivery Date,Pickup Date))

Thank you for your time!
*I don't know if this is relevant but I'm working with a long list of equipment and locations, logged on a table. Entries to the table occur daily, but the report for total days per equipment/location will be weekly.

[jason.b75]

From what I can see your formula is what you need, but it contains one tiny rookie mistake

=IF(Pickup Date="",NETWORKDAYS(Delivery Date,TODAY()),NETWORKDAYS(Delivery Date,Pickup Date))

You need to use ="" to look for a blank cell, not =" ", this works with empty cells and cells that contain a formula but appear empty (blanks).

Similarly, if you use a formula to show a blank cell, then you should also use "" instead of " ".
Using " " in this instance means that you would then possibly need to check the contents twice, once for an empty cell, a second time for a formula that appears empty but shows " ".

[JustMax]

Thanks, jason.b75!
rookie mistake indeed.