Thread
:
Date in Excel Header
View Single Post
#
3
Posted to microsoft.public.excel.misc
Wink20TCU
external usenet poster
Posts: 3
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.
Reply With Quote
Wink20TCU
View Public Profile
Find all posts by Wink20TCU