Thread
:
set a date in columns 7 days apart
View Single Post
#
1
Squirel Eater
Posts: n/a
set a date in columns 7 days apart
How can I set a date in subsequent columns that are 7 days apart? I have
tried
=DAY(IF(B3="","",B3+7)) but if given a date March 6, 2005 it will show 31
days in April. Any suggestions?
Reply With Quote