| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A function incoprating date and a month/monetary value.
I have a column with the months Jan-Dec. In the next column I have a
corresponding monetary value. I want the monetary value for the current month to automatically be shown in the cell and for it to update as the year goes on. I know that I have to recalculate the workbook every day, but still, how do I make this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help about date & month function in Excel | Excel Worksheet Functions | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| =VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MON | Excel Worksheet Functions | |||
| using date function, month shows as January when i type (12) | Excel Discussion (Misc queries) | |||
Threaded Mode
