Requesting Formula in excel on if condition / date function
Closed
KANNAN
-
9 Mar 2015 à 03:49
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 9 Mar 2015 à 08:27
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 9 Mar 2015 à 08:27
Related:
- Requesting Formula in excel on if condition / date function
- Grade formula in excel marksheet - Guide
- Formula to calculate vat in excel - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Formula bar in excel - Guide
1 response
cmarzahn
Posts
35
Registration date
Wednesday 18 February 2015
Status
Member
Last seen
13 March 2015
7
9 Mar 2015 à 08:27
9 Mar 2015 à 08:27
Try this in C1
=IF(OR(WEEKDAY(A1,2)=1,WEEKDAY(A1,2)=2,WEEKDAY(A1,2)=3,WEEKDAY(A1,2)=6),A1+2,IF(WEEKDAY(A1,2)=7,A1+1,IF(WEEKDAY(A1,2)=5,A1+3,IF(WEEKDAY(A1,2)=4,A1+4,""))))
and this in D1
=IF(OR(WEEKDAY(C1,2)=1,WEEKDAY(C1,2)=2,WEEKDAY(C1,2)=3,WEEKDAY(C1,2)=6),C1+2,IF(WEEKDAY(C1,2)=7,C1+1,IF(WEEKDAY(C1,2)=5,C1+3,IF(WEEKDAY(C1,2)=4,C1+4,""))))
Not sure you wanted 2 days on the second. If you are trying to build a week you might need to tamper with the second one a bit.
=IF(OR(WEEKDAY(A1,2)=1,WEEKDAY(A1,2)=2,WEEKDAY(A1,2)=3,WEEKDAY(A1,2)=6),A1+2,IF(WEEKDAY(A1,2)=7,A1+1,IF(WEEKDAY(A1,2)=5,A1+3,IF(WEEKDAY(A1,2)=4,A1+4,""))))
and this in D1
=IF(OR(WEEKDAY(C1,2)=1,WEEKDAY(C1,2)=2,WEEKDAY(C1,2)=3,WEEKDAY(C1,2)=6),C1+2,IF(WEEKDAY(C1,2)=7,C1+1,IF(WEEKDAY(C1,2)=5,C1+3,IF(WEEKDAY(C1,2)=4,C1+4,""))))
Not sure you wanted 2 days on the second. If you are trying to build a week you might need to tamper with the second one a bit.
