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
Function LastDay(DateUsed As Date) As Date LastDay = WorksheetFunction.EoMonth(DateUsed, 0) End Function
and in a procedure
Range("F13") = "=LastDay(d6)"
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