Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
footer date plus 3 months
Hi I'm trying to add a footer with a note that says "this quotation is valid
until ------) ----- being a date calculated to be three months ahead of todays date. Is there a way of doing this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
footer date plus 3 months
ActiveSheet.PageSetup.LeftFooter = _
"This quote is valid until " & Format(DateSerial(Year(Date), Month(Date) + 3, Day(Date)), "dd mmmm yyyy") -- __________________________________ HTH Bob "Richard" wrote in message ... Hi I'm trying to add a footer with a note that says "this quotation is valid until ------) ----- being a date calculated to be three months ahead of todays date. Is there a way of doing this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
footer date plus 3 months
Bob Thanks but I have copied this letter for letter and it is just writing it
out on the footer. It's not actually doing the calculation. How do I make this work? "Bob Phillips" wrote: ActiveSheet.PageSetup.LeftFooter = _ "This quote is valid until " & Format(DateSerial(Year(Date), Month(Date) + 3, Day(Date)), "dd mmmm yyyy") -- __________________________________ HTH Bob "Richard" wrote in message ... Hi I'm trying to add a footer with a note that says "this quotation is valid until ------) ----- being a date calculated to be three months ahead of todays date. Is there a way of doing this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
footer date plus 3 months
Maybe it was wrap-around. Try this variation
ActiveSheet.PageSetup.LeftFooter = _ "This quote is valid until " & Format(DateSerial(Year(Date), _ Month(Date) + 3, Day(Date)), "dd mmmm yyyy") -- __________________________________ HTH Bob "Richard" wrote in message ... Bob Thanks but I have copied this letter for letter and it is just writing it out on the footer. It's not actually doing the calculation. How do I make this work? "Bob Phillips" wrote: ActiveSheet.PageSetup.LeftFooter = _ "This quote is valid until " & Format(DateSerial(Year(Date), Month(Date) + 3, Day(Date)), "dd mmmm yyyy") -- __________________________________ HTH Bob "Richard" wrote in message ... Hi I'm trying to add a footer with a note that says "this quotation is valid until ------) ----- being a date calculated to be three months ahead of todays date. Is there a way of doing this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
footer date plus 3 months
"Richard" wrote in message
... Bob Thanks but I have copied this letter for letter and it is just writing it out on the footer. It's not actually doing the calculation. How do I make this work? Richard, As Bob isn't around at present, try my "newbie" solution! I inserted Bob's code into my "Sheet1" Tab i.e. Right click Sheet Tab View Code and insert the code into Microsoft Excel Objects Sheet1 (Sheet1). Note that you need an extra top and bottom line of code as shown below: Sub LeftFooter() ActiveSheet.PageSetup.LeftFooter = _ "This quote is valid until " & Format(DateSerial(Year(Date), _ Month(Date) + 3, Day(Date)), "dd mmmm yyyy") End Sub Save and close the code window, then in the main Excel window run the macro from Tools Macro Macros select "LeftFooter" Run. Hopefully one of the experts will be along with the right terminology and the proper way to do it. -- Old Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 months prior and 3 months post a date | Excel Worksheet Functions | |||
About calculate months between two date (date function) | Excel Discussion (Misc queries) | |||
Convert date to length of time in months from set date | Excel Worksheet Functions | |||
How can I get yesterdays date in a custom footer &[DATE]-1 does . | Charts and Charting in Excel | |||
Return a date 6 months from a date in another cell | Excel Worksheet Functions |