Solved if statement using dates

October 31, 2013 at 11:52:44
Specs: Macintosh
help!

I have a range of data that i need to analyze.
if a date is 3/1/2014, then i need it to return +15 days later in the next column

and i have many dates that i need to do this do... can you help?


See More: if statement using dates

Report •

#1
October 31, 2013 at 12:02:00
Something like this might work:

=IF(AND(MONTH(A1)=3,DAY(A1)=1,YEAR(A1)=2014), A1+15,"")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
October 31, 2013 at 16:29:56
✔ Best Answer
If you don't want weekends you could use the WORKDAY() function:

=WORKDAY(A1,15)

You can also exclude Holidays if you wish with something like:

=WORKDAY(A1,15,X1:X10)

Where the cells X1 thru X10 contain Holiday dates, like 12/25/2014

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question