Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dates calculation
- Thread starter DanWo
- Start date
I think you would need a UDF for this as I don't believe there is a standard function that would do this. A udf would involve VBA so please confirm you are ok with this before I write something for you
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Thread starter
- #3
A User Defined Function
It's like a macro in that it uses the Visual Basic editor and requires VBA but you can use it on a worksheet. To be honest, if you don't know what a UDF is at this point, it probably isn't the way to go
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
It's like a macro in that it uses the Visual Basic editor and requires VBA but you can use it on a worksheet. To be honest, if you don't know what a UDF is at this point, it probably isn't the way to go
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Status