Hello,
I have a UDF as
which returns the last day of a month given a date. I need to use it in a sub:PHP Code:Function LastDay(DateUsed As Date) As String
LastDay = Format(CDate(WorksheetFunction.EoMonth(DateUsed, 0)), "dd-mm-yy")
End Function
Range("F13") = LastDay(Range("D6"))
but instead of a date, I need cell D6 to show the function =LastDay(D6), can someone please help?
Use the Formula Range property …
My understanding is that a Function returns a value, i.e. a number or a string. I'm not aware it returns a format as well. Hence there seems little point in including a format in the function.
And in any case you presumably want a proper date number returned to excel. In which case I'd be onclined to format the cells in Excel first. Then the function is
Please Login or Register to view this content.
and in a procedure
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
that is exactly what I need, thank you so much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks