| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
yesterdays julian date as filename to link to previous days workbo
I am automating some functions of a power plant. Each day we have a new
workbook. They are named in sequence using the julian date. I need to durive yesterdays file name. I can get the julian dat but to put it in a path and file name in the formula line is a problem. I know the path. I want to use the contents of the cell where I have the Julian date. I can't seem to put it in where it reconizes it. not between []. Can anyone help?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a Date 90 days previous to present date | Excel Worksheet Functions | |||
| Subtract # of days from date, but if not sat, goto previous sat? | Excel Discussion (Misc queries) | |||
| Have a date chane if it is +/- 2 days from the previous date | Excel Discussion (Misc queries) | |||
| In excel,how do I change the date to a date 84 days from previous | Excel Discussion (Misc queries) | |||
| date functions for previous 60/90/180 days | Excel Worksheet Functions | |||
Linear Mode
