Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set a date function for previous monthend?
I know you can create a =NOW() function to give a date stamp to a file. Is it
also possible to have excel return the previous monthend date? |
#2
|
|||
|
|||
Try:
=EOMONTH(TODAY(),-1) This function is part of the Analysis ToolPak add-in. If you do not click Tools, and then click Add-ins to install and enable the Analysis ToolPak add-in, the formula will return a #VALUE error. You will also receive a #VALUE error if either of the function arguments is nonnumeric. "JDP289" wrote: I know you can create a =NOW() function to give a date stamp to a file. Is it also possible to have excel return the previous monthend date? |
#3
|
|||
|
|||
On Thu, 8 Sep 2005 10:12:04 -0700, JDP289
wrote: I know you can create a =NOW() function to give a date stamp to a file. Is it also possible to have excel return the previous monthend date? =TODAY()-DAY(TODAY()) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with a date function formula | Excel Discussion (Misc queries) | |||
Date function | Excel Worksheet Functions | |||
Is there a function to show future date | Excel Worksheet Functions | |||
Date Function | Excel Worksheet Functions | |||
Formula for date function | Excel Worksheet Functions |