View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Wink20TCU Wink20TCU is offline
external usenet poster
 
Posts: 3
Default Date in Excel Header

Will this work in the Custom Header?

"galimi" wrote:

=if(a1<a2,a1-1,a1-3)

Assuming a1 & a2 contain date values, you can simply subtract the number of
days from a date.
--
http://HelpExcel.com




"Wink20TCU" wrote:

Is there a way to modify the date in an Excel Header? I would like to use an
IF function to subtract one or three days depending upon the current date.