Set cell format from a UDF that returns a date

**Steveapa** · 07-28-2015, 11:32 AM

Hi All.

I have written a simple UDF that converts calendar date to my company's Fiscal date. Fiscal date = calendar date - 3 months. I could use Edate(A1,-3) but then I would need to format the cell.

I would like the UDF to do the conversion return the date and then set the format. It does not seem like I can format the select cell in the UDF?

Please Login or Register  to view this content.

**romperstomper** · 07-28-2015, 11:35 AM

You can't do that in a UDF. It can really only return a value to the cell.

**daffodil11** · 07-28-2015, 11:43 AM

To get the functionality you require, I'd use a Worksheet_Change event to trigger on that formula.

Please Login or Register  to view this content.

**Steveapa** · 07-28-2015, 12:53 PM

Thanks. I did not think It could be done. Also, I did not want to tie it to a specific workbook - don't want to use Worksheet Change(). I will just go with the EDATE(A1,-3) and have them do a custom format.

**romperstomper** · 07-28-2015, 04:36 PM

It's not strictly true to say that it can't be done - there are a couple of convoluted options to allow UDFs to do pretty much anything, but they're OTT for this, I would suggest.

Set cell format from a UDF that returns a date

LinkBack

Thread Tools

Rate This Thread

Display

Set cell format from a UDF that returns a date

Re: Set cell format from a UDF that returns a date

Re: Set cell format from a UDF that returns a date

Re: Set cell format from a UDF that returns a date

Re: Set cell format from a UDF that returns a date

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to check if a date falls within a date range, then returns a corresponding cell

Cell returns value if another cell fits within a date range

Check if the cell format is date and change it to date Format(cell.Value, "yyyy/mm/dd")

[SOLVED] Conditional format a cell (contaning a formula) that only returns a positive value

Conditional format a cell when the formula returns False

Date Value Returns a Number in Cell

Function: Cell (format) only returns G when value is Text

How do I add carriage returns within a cell in tab delim. format?

Bookmarks

Bookmarks

Posting Permissions