=Daysdue - calculate days due between two dates

[MrMajinbuu]

Hi Guys,

I came across a function at work which I could not unravel what it is. Much appreciated if anyone can shed some lights.

The excel function reads : =daysdue( date 1, number of days between invoice and due date).

It works totally fine on the one spreadsheet, however the magic appears to be gone when I transferred to another spreadsheet.

Is it a macro? I googled it but couldn't find anything on this function.

Thanks in advance

 

[steve the fish]

Yes its a user defined function. Essentially a macro that acts like a native excel function to do a specific job that the user needs that native functions cant do. Although that said the way its being used there is probably a native function for it.

 

[MrMajinbuu]

Thanks for your prompt reply.

Is there any way I could modify the macro? I have no knowledge about macro but if it is a easy fix I would like to modify the code to suit my needs. Ultimately I would like to change the way it calculates days due.

Thanks heaps.

 

[steve the fish]

Probably. But you need to provide the code and then explain what you want it to do.

 

[MrMajinbuu]

The macro settings all greyed out (except for "Run").

When I hit

Alt+F11, there is a VBAProject on the list, however password is required.

What to do?
​

 

[Fluff]

If you do not know the password, then there is not much we can do to help, unless you have some idea of what the function is doing.

 

[steve the fish]

When you use it what do you use it for? If you dont know what it does then it seems odd to be using it.