| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hard code date in excel . . .
I have a an excel workbook with 15 worksheets that I have to update the prior
month and current year on every month to produce a turnover report. Can I use VB or a DATE function to do this? I have tried =TEXT(TODAY(),"mmmm") but that only gives me the current month and not the year. I need the prior month and current year. Any help is appreciated! Best, Rachel Costanza |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hard code month in Excel | Excel Discussion (Misc queries) | |||
| Not Hard Code If | Excel Discussion (Misc queries) | |||
| Hard-code source data | Charts and Charting in Excel | |||
| Excel hard code those #'s without deleting the formula or typing# | Excel Discussion (Misc queries) | |||
| Excel formula randomly changes to hard-code number | Excel Discussion (Misc queries) | |||
![Rachel Costanza[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
