Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
chuck
 
Posts: n/a
Default How can I get yesterdays date in a custom footer &[DATE]-1 does .

How can I get yesterdays date in a custom footer &[DATE]-1 does not work
  #2   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

try
=today()-1

chuck wrote in message
...
How can I get yesterdays date in a custom footer &[DATE]-1 does not

work


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I enter the date last modified in the footer of an Excel d. Last modified date in footer Excel Discussion (Misc queries) 1 February 6th 05 11:12 PM
change date function format in footer Tori Excel Worksheet Functions 1 January 25th 05 08:18 PM
Print Footer with Last Print Date field name Ted Excel Discussion (Misc queries) 1 December 23rd 04 02:46 PM
Date on two lines using a custom cell format possible? .:mmac:. Excel Discussion (Misc queries) 5 December 4th 04 09:41 PM
Date in Footer Karen Excel Worksheet Functions 1 November 22nd 04 05:33 PM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"