Solved if statement using dates

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

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

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 •

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


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


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


Report •
Related Solutions

Ask Question